Thanks but the macro changes the left and center section as well. I've the date stamp on the right section in the header. The left and center sections of the header are specific to the Sheets but the date (right section) can be applied to all Sheets. I think I might be able to start from the...
I mean the tab (Sheet1, Sheet2, Sheet3, etc....) at the bottom of each worksheet. Inserting the date on Sheet1 just change the date on all sheets in Sheet1. It did NOT change the date in Sheet2, Sheet3, etc.....
How do I change the date on all Sheets in the spreadsheet?
Thanks,
Hi Guru,
Question:
Overview: I've multiple sheets in my Excel spreadsheet. I insert date and time in the footer of every page in all sheets.
1. How do I retain the last modified date and time? Each time I open the file. the date and time change even though the file was NOT save. Hence, when...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.