koala
09-01-2005, 03:47 AM
Hello Forum,
I have a workbook with a lot of sheets in it (approx 70).
Different sheet categories have their own colour Tabs.
Some of my macros are only required to run on certain sheets, so therefore I need to be able to select those in a code.
Currently I hard code the names into my macro, but as other sheets sometimes get added, this is not a very good way to do it.
I was wondering if it is possible to select sheets by their TAB colour. (I am running Excel XP).
Alternatively, does anyone know another way that might also work?
Hoping someone is able to assist
Thanks in advance
Koala
I have a workbook with a lot of sheets in it (approx 70).
Different sheet categories have their own colour Tabs.
Some of my macros are only required to run on certain sheets, so therefore I need to be able to select those in a code.
Currently I hard code the names into my macro, but as other sheets sometimes get added, this is not a very good way to do it.
I was wondering if it is possible to select sheets by their TAB colour. (I am running Excel XP).
Alternatively, does anyone know another way that might also work?
Hoping someone is able to assist
Thanks in advance
Koala