Vba Worksheet Activate Not Firing. 21 posts related to excel worksheet activate event not firing. Private sub workbook open bug in excel.
The worksheet activate event does not fire for the sheet that is active when the workbook is opened so call it explicitely. Worksheet activate event not fires worksheet events do not fire when the workbook is opened. It works fine if i open that worksheet outside vba.
Private sub workbook open bug in excel.
The attached private sub worksheet activate code is in my combined worksheet object in wb2. Worksheet activate and deactivate not working i have found a solution at least for my case. The worksheet activate event does not fire for the sheet that is active when the workbook is opened so call it explicitely. Make sure that worksheet activate is declared as public.