Mask the password with *** (asterisk)

Hi

I have this code I use for hiding several sheets:

Please Login or Register  to view this content.

screenshot.1.jpg

when I write password in confirmation dialog it can be seen, is there a code where I could mask it with *** (asterisk)?
tnx

Good morning perko121

xlnitwit's quite correct - it's much easier to create a userform and do it that way. But just for completeness, here's how it's done using API calls (with all due credit to Daniel Klann and Ivan F Moala).
way

Please Login or Register  to view this content.

Thank you,

how is it done with userform, I would like to test it maybe it will be better option for me?

What I need is password prompt form each time document is opened that would show visible sheets if password is correct, if pressed "cancel" it will open only sheets that are not password protected.

Hi perko121

From the VBE got to Insert > UserForm.

Draw a textbox (make sure it's called TextBox1) and a command button (CommandButton1).

Right click and select "View Code" to open the pane where the code that drives the form can sit and copy this into it :

Please Login or Register  to view this content.

Call the userform from another module using :

Please Login or Register  to view this content.

HTH

DominicB