Command Button that shows Hidden Sheets - Needs Password Protection

Hi, John,

if you want to use the InputBox the only way I know is to use API to mask the characters being entered. I would recommend you have a look at UserForms where you may add a Textbox (PasswordChar can be given there) which would mask the entry without further notice. A simple UserForm could consist of one label for some explanation what to do, one textbox for the entry, one commandbutton for cancelling and one for submit with the code to check like given above (and the command to unload the userform)

Ciao,
Holger