Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
floating toolbar to stay put BorisS Excel Discussion (Misc queries) 2 December 3rd 06 08:47 PM
Floating Toolbar Dave Excel Discussion (Misc queries) 4 April 29th 05 04:57 PM
PDF 4.0 Floating Toolbar Darrell Excel Discussion (Misc queries) 1 February 10th 05 06:14 PM
Floating Toolbar Roger Bedford[_2_] Excel Programming 2 July 6th 04 06:03 PM
Floating Toolbar Questions Shatin Excel Programming 2 February 22nd 04 11:55 AM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"