How to hide and unhide sheets with a password

[holli]

I have the below formula which uses a password to allow worksheets to be hidden and unhidden. I cant seem to get it to hide and unhide more than one sheet. It will only hide "SES MAIN". I have typed the names exactly as on the work sheets. Am I missing something?

Please Login or Register  to view this content.

[TMS]

How many sheets are there? You must always have one sheet visible.

Regards, TMS

[holli]

There are 52 sheets so there will still be many visible sheets.

[TMS]

Comment out the On Error Resume Next and see if you get an error. If you get subscript out of range, there is an issue. Maybe leading or trailing space(s)

[holli]

Yes I get the error.

I tried replacing the worksheet names for the worksheet numbers but now it only hides the other sheet "JES Software" . I'm puzzled.

[TMS]

Suggest you post a sample workbook. It can be (a copy of) the real thing with all the data deleted. Only need to see the sheets/structure.

[holli]

I have created a very basic example with just three pages.
test hide-unhide.xlsm