I have 52 sheets (one for every week of the year) an dI would like to highlight the sheet tab for the date that is occurring this week. It should also un color when it moves on to the following week.
Sheets named as "Dec 9, 2022" or "Apr 4, 2022" Etc. They're based on week ending dates (based on Fridays)
Not sure if this is even possible but worth a shot. I would just like to have the current week highlighted so the user entering data can find the current sheet easily. Other option would just be a macro that jumps to current date, but they can already kind of do that with the built in Sheet jumplist.
Bookmarks