Hello everyone. I am new to VB and this forum. TIA for any assistance anyone can provide.
I am looking for a macro/VBA code that will rename sheets 1-7 as "Sunday MMDDYY" thru "Saturday MMDDYY", respectively. Ideally, it would trigger based on the change of a single cell in sheet10. The sheet10 B1 cell contains a text date value that will be edited by the spreadsheet user at the end of each week to update dates in the sheet names and spreadsheet calculations for the next weeks information. I have everything done except the tab auto rename which I am struggling with, not knowing VB very well.
Alternately, all A1 cells of sheet1 - sheet7 have a date but it is a referenced value from sheet10 cell B1 so the sub function I have found does not work since those cell values are not text.
Any help would be greatly appreciated. thanks much.
Bookmarks