Running Excel Macros
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.
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 AutoOpen. Similarly, you can cause a macro to run when a workbook closes by calling it AutoClose. AutoOpen macros can be particularly useful, for example, if you want to refresh data from an external source whenever you open a workbook.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.