Hi Robrobet,
You could try adding an Auto_Open macro like this:
This code assumes that the days will always have two characters in the sheet tab name, and that the month part will always be three characters. If this isn't the case then you will need to amend the code accordingly. Also, you could refine the (Date-7) and (Date + 7) parts to refine so that only one week tab appeared.
The other issue with hiding sheets is that at least one sheet always needs to be visible. If the current week tab wasn't currently visible, and this routine tried to hide all of the other tabs before un-hiding the current week tab then Excel would cause an error to occur (this is why I added the On Error Resume Next line). An alternative is to first unhide all of the worksheets in the code and then run my code.
Hope this helps,
Simon.
Bookmarks