I have a worksheet which has tabs that go from the 1st of the month to the last. I want to have the current days date tab a different colour to the rest when I first open the sheet ie if its the 17th april that tab is red the rest are another colour) I know I can do this manually but wondered if there is a VBA that will do it when I first open the worksheet?
I have a VBS that currently automatically opens the correct amount of tabs and names them I wondered if this could be added to?
I am quite a novice at this and would appreciate any help
Bookmarks