| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide toolbar automatically when I switch to other worksheet
I have five worksheets in one workbook. I try to make a bar just for the one
worksheet (name is class) and is only visible when the "class" worksheet is active. Please help me! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to hide toolbar automatically when I switch to other worksheet
Use the Worksheet_Activate and Worksheet_Deactivate events.
NickHK "Wei" wrote in message ... I have five worksheets in one workbook. I try to make a bar just for the one worksheet (name is class) and is only visible when the "class" worksheet is active. Please help me! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to hide toolbar automatically when I switch to other works
NickHK,
Thanks so much for your help! I tried this command before but in the wrong way and wrong place (module) ..... Worksheet("Sheet Name")_Activate Toolbars("toolbar name").Visible=True ..... ..... Worksheet("Sheet Name")_Deactivate Toolbars("toolbar name").Visible=False ..... Now I know I have to put the code in the specific sheet and ..... Worksheet_Activate Toolbars("toolbar name").Visible=True ..... ..... Worksheet_Deactivate Toolbars("toolbar name").Visible=False ..... Thanks again! Wei "NickHK" wrote: Use the Worksheet_Activate and Worksheet_Deactivate events. NickHK "Wei" wrote in message ... I have five worksheets in one workbook. I try to make a bar just for the one worksheet (name is class) and is only visible when the "class" worksheet is active. Please help me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| new unwanted toolbar i can't switch off | Excel Discussion (Misc queries) | |||
| How to print worksheet and automatically hide zero value rows? | Excel Discussion (Misc queries) | |||
| How to hide toolbar automatically when I switch to other worksheet | Excel Discussion (Misc queries) | |||
| VBA toolbar-button programming switch on/off | Excel Programming | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Hybrid Mode
