Date: | 17/09/2020 |
---|---|
Time: | 1:00 PM AEST |
Event: | Macros 4 – Automating Macros with Events |
Topic: | Macros |
Public: | Public |
Registration: | Click here to register. |
Macros 4 – Automating Macros with Events
Price: $25 incl GST
Duration: 1 hour
You can automate your macros by taking advantage of Excel’s built-in event monitoring system. Excel watches what you do and some of your actions can trigger what is called an event.
When an event is triggered it can run macro code. Things like opening or closing the file can trigger an event. In a sheet changing an entry will trigger an event.
For example you can choose what sheets to display when a file is opened and build in robust input validation checks to your sheets.
These techniques can improve the user experience and ensure macros are run when you need them run.