I have over 30 worksheets in one workbook. I would like the user to be able to hide and unhide worksheets based on a value in a certain cell in the "main" worksheet.

For example if cell A1=CP, then all worksheets will be hidden except "sheet1". If A1 was changed to LQ then "sheet2" be visible and all others be hidden.

Hopefully this makes sense.

Any help will be appreciated.