Event Procedure Excel VBA - workbook_activate
In today’s video we will discuss about Event Procedure workbook_activate.
Excel has the ability to automatically run/execute any code when Excel Workbook state changes from inactive to active.
By Default, Events are enable in Workbook and disabling events applies to all the workbooks. For Example, if we disable the events in one workbook and would like to open another workbook which has event then it will not work.
Enable Events: Application.EnableEvents=True
Disable Events: Application.EnableEvents=False
