Hide "x" number of worksheets

[eriknokc]

I use a various number of workbooks that I need this to work on. The first 2 worksheets are summary worksheets and after that there is a worksheet for each day of the month. As each week passes I need to hide the 6 worksheets for the previous week (mon-sat). I would normally be able to hide worksheets with a macro using the names, but the different tabs are named for each day of the month. Is there a way to make a macro to skip the first 2 worksheets and hide the next 6? Or maybe a macro where you could hide 6 sheets starting from the current worksheet selected? Any help provided will be greatly appreciated.

[royUK]

Try this

Please Login or Register  to view this content.

[eriknokc]

That sorta does the trick. That hides all the worksheets past the first 2, but I am looking to only hide the first 6 worksheets after the 1st 2. That's more progress than I was able to get. Thanks so much for your help!

[shg]

Maybe ...

Please Login or Register  to view this content.

[eriknokc]

Unfortunately that did not do anything to any of the sheets

[shg]

I dunno about that. Post a workbook that demonstrates.