Show or Hide Sheet Help

[SilverBullet17]

Hi All

Is there any way to hide a sheet based on the values I input into a cell without using VBA (see attached example)? I have VERY limited skills and have only ever written a basic Macro...

Thanks!

Silverbullet

[TMS]

Short story: no. You would need VBA.

[Logit]

.

Please Login or Register  to view this content.

Paste in Sheet 1 l Module

[Root_]

@Logit:

There are two issues with your code:

1. It will not work if there is no selection change -- for example, if the user types "Hide" in cell C3 and presses Ctrl+Enter.

2. When the user unhides Sheet2 and changes selection on Sheet1, Sheet2 hides again.

[TMS]

Should be a Worksheet_Change Event handler.

[Root_]

Should be a Worksheet_Change Event handler.

Yes -- and, probably, clearing/changing C3.

[Logit]

.
I believe this addresses your concerns :

Please Login or Register  to view this content.

If not please advise. Thanks