Lock and Hide Sheets based on Tab Color

[WFM PRO]

Hello,

I'm looking for a macro solution to "Close" (Hide) Sheets based on the Color of the tab.

In a workbook with colored tabs, where BLACK tabs are "Raw Data", GREEN are Graphical tabs, etc., I am intending for the macro, when activated, will (for example) lock and hide all RED tabs.

I thought that this would work:

Please Login or Register  to view this content.

...but, it does nothing. Any ideas on how to make this work?

[xladept]

Hi WFM,

I'd be leery of the protect part - but this may be what you want:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[WFM PRO]

That worked PERFECTLY!

Thank You.

[xladept]

You're welcome!