hide and unhide worksheets

[pankaj2145]

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.

[mikerickson]

If Sheet1!A1 is "CP" then all sheets are hidden except for Sheet1.
If Sheet1!A1 is "LQ" then all sheets are hidden except for Sheet2.

At that point, how does the user change the (now hidden) Sheet1!A1 back to "CP"?

[pankaj2145]

if the user selects CP again the hidden sheets should be visible.

[teylyn]

how can the user set Sheet1!A1 back to CP if the sheet is hidden???

[Launchnet]

He must be stating that the Main Sheet is always open and che codes are entered on that sheet.