tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
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