48 HOURS ONLY: Get 2 free months of Insider Pro!

Running Excel Macros

Practice Labs Module
Time
51 minutes
Difficulty
Intermediate

The "Running Excel Macros" module provides you with the instructions and devices to develop your hands on skills in the following topics: Assigning Macros to Commands, Buttons and Objects, Running Macros on Opened or Closed Workbook.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Running Excel Macros module provides you with the instructions and devices to develop your hands on skills in the following topics.

  • Assigning Macros to Commands, Buttons and Objects
  • Running Macros on Opened or Closed Workbook

Lab time: It will take approximately 60 minutes to complete this lab.

Exercise 2 - Running Macros on Opened or Closed Workbook

You can cause a macro to run automatically when a workbook opens simply by naming it Auto_Open. Similarly, you can cause a macro to run when a workbook closes by calling it Auto_Close. AutoOpen macros can be particularly useful, for example, if you want to refresh data from an external source whenever you open a workbook.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.