Help! My customized menu bar is gone.

[Steve C]

Hi experts,
I have an Excel application with customized menu bar for
users to perform various tasks. Yesterday, one of the
users told me that when he launched Microsoft Word and
pressed the "Insert Microsoft Excel Worksheet", the
customized menu bar had gone when he switched back to my
application. Thus, what he see is the normal Excel menu
and the all the tasks in the application cannot be
performed afterwards. I had tried several workbook events
to trap this situation but it didn't work.
Could anyone tell me how to tackle this problem?
Appreciate your help in advance.

 

[JE McGimpsey]

It sounds like one of your event macros hid or deleted the menu, as
simply adding a worksheet shouldn't affect toolbars. Do you have an
event macro that does this?

 

[Paul Robinson]

Hi
Did your user try saving an Excel file, then cancelled the save? This
will still run your Auto_Close sub and remove the menu bar. If that
was the problem, there is a simple workaround on Dave Walkenbach's
site (I think)

regards
Paul

 

[Steve C]

Hi JE,
you're correct. Under debug mode I found that the
Workbook_Deactivate() event in which I have codes to
delete the menu was fired. Many thanks for your advice.