L
Legacy 489182
Guest
Hi,
I’m wanting to hide 5 worksheets within an excel document and then based on the value of a particular cell on my front sheet (sheet1) unhide certain sheets.
For example if the value in cell E10 on Sheet1 was 0 or blank I would want sheet1 visible.
If the value changed to 1 I would want only sheet1 and sheet2 visible. If this was changed to 2 I would want sheet1, sheet2 and sheet3 visible etc.
Is there a way of doing this? I’ve struggled to find an answer to this so any help would be appreciated!
I’m wanting to hide 5 worksheets within an excel document and then based on the value of a particular cell on my front sheet (sheet1) unhide certain sheets.
For example if the value in cell E10 on Sheet1 was 0 or blank I would want sheet1 visible.
If the value changed to 1 I would want only sheet1 and sheet2 visible. If this was changed to 2 I would want sheet1, sheet2 and sheet3 visible etc.
Is there a way of doing this? I’ve struggled to find an answer to this so any help would be appreciated!