Originally Posted by
dhregan
Thank you, Paul. But when you first open a workbook, isn't Application.EnableEvents = True always, or does it retain the setting from when last saved?
When Excel opens, Application.EnableEvents = True, but if
1. WB #1 sets Application.EnableEvents = False
2. WB#1 is closed, but Excel is not
3. WB#2 opened (e.g. File, Open) then the Application.EnableEvents status is persistent
Example:
a. Open Excel
b. File Open WB1.xlsm - WB Open files with message, and turns EnableEvents off
c. File Close WB1.xlsm, but leave Excel Open
. d. File Open WB2.xlsm - WB Open event does not file
e. Close Excel
f. Open Excel and Open WB2 - WB Open fires
I always turn off EnableEvent, do only what might cause an event handler to be called, and turn it on again -- usually within 2-3 lines, but always in the same sub