Hiding a worksheet based on a calculated cell value

[GuruWannaB]

FYI...I love this site and all the help everyone provides!!

I have a protected spreadsheet with three worksheets.
-Worksheet A is always visible and is a form with multiple checkboxes where the true/false output is placed in a hidden column.
-Worksheet B is always hidden and basically does all sorts of calculations and manipulations of data based on input received on Worksheet A.
-Worksheet C is one that I want to keep hidden until all checkboxes on Worksheet A have been checkmarked.

I have a cell on worksheet B (the data manipulation worksheet) that has a formula that will provide a "Y" value or "N" value based on whether all checkboxes on worksheet A have been checkmarked or not....I just need something that will automatically trigger worksheet C to become unhidden once that cell's value (in worksheet B) is "Y" and hides again when the value is "N".

Any help would be greatly appreciated! This site and all of those that provide suggestions are the best!

Thanks in advance!!

[Rick_Stanich]

My suggestion:
This will hide and unhide a Sheet named "C" if the value in Sheet named "B" at cell "A1" is "Y" (Hide) or "N" (Unhide).

Please Login or Register  to view this content.

I am now the Best