Hi
How to hide sheets that have a sheet tab with a specific theme color name (default theme color name) assigned, such as:
Background 1, Darker 50%
Background 2, Darker 90%
Text 1, Lighter 5%
Text 2, Darker 50%
Accent 1, Darker 50%
Accent 2, Darker 50%
Accent 3, Darker 50%
Accent 4, Darker 50%
Accent 5, Darker 50%
Accent 6, Darker 50%

In other words, all the TABs (sheet2 to sheet9) which colored with the theme color will be automatically hidden when I close the workbook , and also protect structure and windows with password (1234) .
How can I do that via vba code please? Do you have any other better ideas?
Many thanks
J.