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.

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.

I am reading volumes into your succinct comment. I am assuming that you are
suggesting that getting rid of these will eliminate my problems. I would
have a harder time getting rid of _Open than _BeforeClose. I will try
getting rid of _BeforeClose, and putting it's limited functionallity into
_Deactivate. Let me know if I am totally misinterpretting this.

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.

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.

From your slightly later post it sounds like you've got it all sorted, but a
quick comment about my first post.

I didn't really intend you to 'read volumes into my succinct comment', but
for it to be taken at face value as a question, perhaps after a quick check
that all works fine without those events (sounds like it does, guess they
are 'attached' bars).

But you may well have come back with something like - yes, the open/close
events are needed to create and destroy the custom toolbars when the wb
opens/closes and the de-/activate to toggle visible as required. Had that
been the case I would have gone on to suggest a slight modification.

Anyway, glad the question probed the solution!

Regards,
Peter T


"ZipCurs" wrote in message
...
I am reading volumes into your succinct comment. I am assuming that you
are
suggesting that getting rid of these will eliminate my problems. I would
have a harder time getting rid of _Open than _BeforeClose. I will try
getting rid of _BeforeClose, and putting it's limited functionallity into
_Deactivate. Let me know if I am totally misinterpretting this.

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.