Show and hide tab macro problem

blaksnm

Active Member
Joined
Dec 15, 2009
Messages
498
Hey guys
Problem:
Comandbutton/macro that shows all tabs in my workbook and hide all tabs on next click, then next cklick: show ... and so on.

ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayWorkbookTabs = True
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
ActiveWindow.DisplayWorkbookTabs = Not ActiveWindow.DisplayWorkbookTabs
 

Watch MrExcel Video

Forum statistics

Threads
1,108,998
Messages
5,526,161
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top