floating toolbar
 

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

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27358

floating toolbar
 

Look at the "Collection of buttons" example on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"scottwilsonx" wrote in message
...

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

floating toolbar
 

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