question

MrMJ-5923 avatar image
0 Votes"
MrMJ-5923 asked MrMJ-5923 published

How to hide (Very hidden) worksheet based on sheet Tab Color when closing workbook?

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%

192284-1.png

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.


office-vba-devoffice-excel-itprooffice-scripts-excel-dev
1.png (289.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers