I have a password protected workbook. When I enter the password in the dialog box, the password shows up! This just started happening last week; before that, it was fine. What can I change to make the dots appear instead of the actual password?
I have a password protected workbook. When I enter the password in the dialog box, the password shows up! This just started happening last week; before that, it was fine. What can I change to make the dots appear instead of the actual password?
You are probably using a userform.
If so, you will have to specify a password character in the userform's text box properties.
Mike 1001
_________________________
Let's keep trying, one day we'll succeed!
I am not using a 'userform'. I am new to VBA. Here's what I have for my code:
Please Login or Register to view this content.
Last edited by jlheath01; 10-24-2014 at 01:04 PM.
I wouldn't know how one could hide a password by dummy characters in a simple input box!
Just use a userform; it's not so difficult.
Same as you can add modules in the VBA editor, you can add forms as well.
All you need is a label to replace your InputBox's prompt and a text box which would be used to type the password.
Thanks for the assistance. Unfortunately, I'm not sure how to go about what you're saying since I'm not that familiar with VBA as you can see with the above code.
Hi, jlheath01,
Your post #3 does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Sorry, I am fairly new to forums and their rules.
Does this meet the criteria?
Please Login or Register to view this content.
Hi, jlheath01,
if I´m honest I would have preferrred that you edit the post instead of posting a new one - this leaves the old one still without the tags.
If you want to stick with the InputBox you will have to use API to mask the characters, there is no way to do it in VBA wirth an InputBox directoly. If you try and experience with a UserForm you might add a textbox there with your choice of password character. Additionaly there would be a label for a description, two buttons (one for Cancel, one for Submit).
Ciao,
Holger
I have fixed the post. I didn't see Edit as an option before. I don't necessarily want to keep the InputBox. I'm looking for help in creating code which would allow me to have one user with an admin password view all sheets and other users have their own password to see their own sheets in addition to the Instructions sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks