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!