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.

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.