Hi create the code to activate/ deactivate in the workbook_activate and
workbook_deactivate events

"scottwilsonx" wrote:


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

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

Thanks for your help
Scott.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=273583