floating toolbar

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

Hi all, I am using Excel2000, and have just created a new menu-bar usin
the menu options.

Unfortunately, I only want the new menu-bar to be available when usin
one programme, however at the moment whenever I open Excel the new men
is available. Is there a way to disable the view when opening Excel, o
to create a menubar that is only available in the one programme ?

Thanks for your help
Scott
 
Hi create the code to activate/ deactivate in the workbook_activate and
workbook_deactivate events
 
Back
Top