Is it possible to somehow add a note to every sheet in use?

[tonywatsonhelp]

Hi Everyone,
I'm not sure the best way to do this so i'll just describe what I'm truing to do.

I'm in document clean-up mode,
I have a lot of sheets with what looks like nonsense and old stuff in my document, most put there by other people over the last 10 years !

I'm trying to reduce the document size and have got to the bit where i want to remove unused sheets.

so hears what I'm thinking

Is there a way I could add a bit of code to a macro (Or have it automatically run!) that somehow shows me if a sheets has been used to complete its tasks?
for example, none of my sheets have data in A1 so maybe we could have something that says "Any sheet you need to use to run this macro including macros that are called, just put a USED in A1"
it can be anything, make the tab colour bright Green! create a list, i don't mind how i do it,
I have about 15 buttons that run macros so anything i can implement will help,
I've been trying to do in manually, I'm into day two and losing the will to live! please help
Any ideas would be appreciated.
Thanks
Tony

 

[bobsan42]

Well it depends on how thorough you want to be.
You can add some code 8n the thisworbook module under sheetactivate event or sheetchange event to mark a cell with date and time or log the event on a hidden sheet. Then use this information to delete old sheets.
However such approach will take time to collect enough information to be considered reliable.

 

[tonywatsonhelp]

Hi Bob,
thanks for the advice,
currently i doing it by hand and its working great, I just thought if i can do this surly VBA can?
But I appreciate sometimes we are the answer,
Thanks anyway for your help