Closing Excel and Events
Wow!!! That was easy. Thanks.
"Peter T" wrote:
Do you really need the Workbook_Open and the BeforeClose.
Regards,
Peter T
"ZipCurs" wrote in message
...
I have a number of spreadsheets with customized menu bars across the top.
In
each of these, I use Workbook_Open, _Activate, _Deactivate, and
_BeforeClose
to ensure that the right custom menus end up on the right worksheets as I
move from on workbook to another.
The only problem I have is when I have multiple workbooks open and close
Excel, I seem to get caught in a loop. I need to run the _BeforeClose and
I
need to have .EnableEvents=True the next time any of the files is opened.
How can I do this? Thanks in advance.
|