How to hide toolbar automatically when I switch to other worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop to hide sheet based on cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet toolbar 6
How to hide toolbar automatically when I switch to other worksheet 4
Worksheets and Events 5
Protect each worksheet individually 4
detecting a proteced workbook 4
Excel crashes and restarts when accessing newly created worksheet 2

Back
Top