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

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

Try this one:

Please Login or Register  to view this content.