Forum Discussion
How can I create a last modified macro for each worksheet?
Hi All, I want to create a macro so that I can see the last modified date for each worksheet not the entire workbook*. How do I go about this? I tried to modify the last modified formula so that ...
Copy the code from the ThisWorkbook module in the sample workbook to the ThisWorkbook module of your own workbook.
Save your workbook as a macro-enabled workbook (*.xlsm), if it isn't a macro-enabled workbook already.
Make sure that you allow macros when you open it.
Got it. I have put it on the workbook code. How do I get it to then list the sheet modified dates for the sheets I want to see in a specific cell? Thanks
If you want a timestamp for the majority of sheets, specify the ones you don't want to have a timestamp.
If you want a timestamp for a minority of sheets, specify the ones you do want to have a timestamp.
Please explain in detail where you want the timestamps to appear.
- Ah yes, I can see it populating now. How can I specify which sheets I want to see? (I do not want it to generate for every sheet clicked on only specific ones). Is it also possible to choose which cells it populates in? I can see it appear but I need it to be in another place and when I move it to another cell and edit again it reappears in the original space. Thanks!
Have you tested editing some cells in various sheets? The code should take care of everything automatically.
Let me know if it doesn't do what you want.
