Event Procedure Excel VBA - workbook_open
In today’s video we will discuss about Event Procedure Workbook_open.
Excel has the ability to automatically run/execute any code when opening an Excel Workbook.
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
Example: We will create 3 sheets (Main, Admin, Users) and create a workbook Open Event which will be triggered while workbook will be open and make visible only Main Sheet then ask from users while they would like to open Admin Sheet or Users. As per response Only 1 sheet will be opened and other 2 will be hidden.
