Wise Owl Answers - How do I make a VBA event work in every workbook?

By Andrew Gould

This video shows you how to use VBA in Excel to enable application-level events which will run in any workbook that you have open. You'll learn how to create a class module, how to declare an application variable with events and how to activate application-level events.

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
   / @wiseowltutorials  

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Chapters
00:00 The Question
00:39 Worksheet and Workbook Events
04:07 Declaring Variables With Events
06:31 Activating Application Level Events
09:23 Deactivating Application Level Events
11:30 Using the Personal Macro Workbook
15:10 Enabling Application Events Automatically

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!