Password Unhide Sheets

[fredfarmer]

Hello,

I have this code to unhide certain sheets. If the wrong password is entered it shows the sheets and them hides them.

Can this be modified so it doesn't show the hidden sheets if the wrong password is entered?

Thanks,
Fred

Please Login or Register  to view this content.

[TMS]

You don’t test the password. What would indicate if it were correct or not?

[fredfarmer]

I might have changed the code in the attached trying different ways.

[fredfarmer]

I have the macro attached to the shape 'Unhide Sheets' on the Search sheet.

[TMS]

In the code in the OP, you use InputBox to ask for a password, pwd. Then, regardless of what is input, correct, incorrect, nothing, or cancel, you just drop through the next lines of code which unhide all the sheets.

You would need to test immediately after the InputBox to see if a valid password has been input. Either that, or move the code after the point where you try to UnProtect the sheets. But, even then, you have error trapping so that you can test the error code.

I think you need to rethink the logic of what you are trying to do.

You do realise that you don't need to make the sheets visible in order to unprotect them, don't you?

[BoredWorker]

it should be

Please Login or Register  to view this content.