Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbar Visibility
I have a workbook with multiple custom toolbars. Some only work right on a
single worksheet. Is there a way to have only Custom Toolbar 1 visible when sheet 1 is selected, only Custom Toolbar 2 visible when sheet 2 is selected, etc.? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbar Visibility
You need to make them visible/not visible in the appropriate worksheet
Activate/Deactivate events. Private Sub Worksheet_Activate() Application.CommandBars("myToolbar").Visible = True End Sub Private Sub Worksheet_Deactivate() Application.CommandBars("myToolbar").Visible = False End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "RCW" wrote in message ... I have a workbook with multiple custom toolbars. Some only work right on a single worksheet. Is there a way to have only Custom Toolbar 1 visible when sheet 1 is selected, only Custom Toolbar 2 visible when sheet 2 is selected, etc.? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbar Visibility
Worked great. Thanks alot.
"Bob Phillips" wrote: You need to make them visible/not visible in the appropriate worksheet Activate/Deactivate events. Private Sub Worksheet_Activate() Application.CommandBars("myToolbar").Visible = True End Sub Private Sub Worksheet_Deactivate() Application.CommandBars("myToolbar").Visible = False End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "RCW" wrote in message ... I have a workbook with multiple custom toolbars. Some only work right on a single worksheet. Is there a way to have only Custom Toolbar 1 visible when sheet 1 is selected, only Custom Toolbar 2 visible when sheet 2 is selected, etc.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Macro Toolbar? | Excel Discussion (Misc queries) | |||
Toolbar problem | Excel Discussion (Misc queries) | |||
Loading custom toolbar | Excel Discussion (Misc queries) | |||
How can I attach a custom toolbar to only appear on one specific . | Excel Worksheet Functions | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel |