LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Displaying Custom Toolbar in Specific Worksheet

Excel 2000

I've created a custom toolbar that I want to have displayed in only one
specific workbook. I copied the toolbar to the workbook, and added the
following routine to the ThisDocument module of the workbook (to ensure that
the toolbar is always visible when the workbook is opened).

Private Sub Workbook_Open()

Application.CommandBars("MyToolbar").Visible = True

End Sub

For some reason, the toolbar is visible in all workbooks. If I close it in
one workbook, it gets closed in all workbooks. If I make it visible in one
workbook, it will be visible in all workbooks, and will even be visible when
there are no workbooks opened.

I know how to do this in Word (add the toolbar to the specific document or
template, remove it from Normal.dot, and use the Word equivalent of the
above code in the Document_Open routine). I've been working on the
assumption that the solution in Excel will be similar to the solution in
Word, but it seems that toolbars are handled a bit differently in Excel.

How can I make the custom toolbar available to only a specific workbook.

--Tom


 
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
Save Macro and Custom Toolbar in Worksheet Pat Excel Discussion (Misc queries) 1 April 24th 08 04:12 AM
Isolating a custom toolbar to a specific spreadsheet Gilgamesh Excel Discussion (Misc queries) 3 October 14th 05 01:30 PM
How can I attach a custom toolbar to only appear on one specific . ABuia Excel Worksheet Functions 1 January 18th 05 02:57 PM
Add custom Worksheet and Toolbar in shared drive jrcruzr Excel Discussion (Misc queries) 1 December 10th 04 11:06 PM
Displaying a specific worksheet on opening application John Excel Programming 1 February 19th 04 12:27 PM


All times are GMT +1. The time now is 12:15 AM.

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"