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!

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!

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!