Hide sheet macro based on date

[nickmax1]

I have many sheets in my workbook labelled in the format MMM YYYY

So Jan 2013, Feb 2013 etc all the way up to Dec 2013 (currently) and as far back as Aug 2012.

What I want to do is to have a macro that will hide the sheets with dates that are more than 2 months old and more than 2 months in the future of todays date.....
I do have other sheets in my workbook so those need to remain visible (called "Start", "Template", "Users" and "Graphs")

If it helps, each sheet that is labelled in the format Mmm YYYY has in it the named range "sh.name" which is the sheet name (funnily enough) in cell A1 of each sheet.

any ideas?

[JBeaucaire]

You may need to play withe +60 -60 stuff, but something like this:

Please Login or Register  to view this content.

or...

Please Login or Register  to view this content.

[nickmax1]

Wow JBeaucaire your code work very well - how would I reverse the code to unhide all the sheets that were hidden by your macro?

I think i managed it with this:

Please Login or Register  to view this content.

[JBeaucaire]

My macro does both, it hides an unhides based off of the dates. Yours looks good for an all-purpose unhide all sheets. But if you just want them all showing then this is even easier:

Please Login or Register  to view this content.

[nickmax1]

JBeaucaire
Thanks for your suggestion, but like I said I do have some sheets that are not in the Mmm Yyyy format that i want to remain hidden