MM0058 - 11/01/21 - Workbook Event Macros: Pros And Cons
Did you know you can trigger macros using what are called workbook 'events'? Sounds interesting, right? But, there can be unwanted side effects that might confuse and / or infuriate you or your customer! So in this session, let's understand the pros and cons of workbook event macros.
Topics
Topics
- | Different Ways To Trigger A Macro
- | Run A Macro With A Shortcut Key
- | How To Use The Macros List
- | Event' - Explanation
- | Macro Triggered By Cell Change - Example
- | How To Find Events To Trigger Macros
- | Why Chris Doesn’t Use Event Macros
- | How To Scroll To Top Of Sheet When Selected
- | Spreadsheets Is Hearts And Minds!
- | Story About Unsuccessful Excel Project
- | How To Access Userform Events
- | How To Avoid Shrinking Userforms
- | Events: Recommended And Not
- | Chat With Tony L
- | Possible Sources Of Inefficiency
1 Lesson