Using date format and left function with worksheet name to hide worksheet

[rgullett]

the problem I am having is that the code below hides all tabs except the summary tab.

The spreadsheet has 12 tabs; each tab’s name is in the following format Jan 2012 Act-Bud-Var
On the summary tab I created a button that I will use to hide all tabs except the summary tab and the current month’s tab.

Please Login or Register  to view this content.

thank you for your help

[protonLeah]

Try this one:

Please Login or Register  to view this content.

[rgullett]

Your code solved it thank you.