Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save Macro and Custom Toolbar in Worksheet | Excel Discussion (Misc queries) | |||
Isolating a custom toolbar to a specific spreadsheet | Excel Discussion (Misc queries) | |||
How can I attach a custom toolbar to only appear on one specific . | Excel Worksheet Functions | |||
Add custom Worksheet and Toolbar in shared drive | Excel Discussion (Misc queries) | |||
Displaying a specific worksheet on opening application | Excel Programming |