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!