+ Reply to Thread
Results 1 to 9 of 9

Password is displaying instead of dots

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    28

    Password is displaying instead of dots

    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?

  2. #2
    Forum Contributor
    Join Date
    01-31-2007
    Location
    Aschaffenburg, Germany
    MS-Off Ver
    Office 2013
    Posts
    104

    Re: Password is displaying instead of dots

    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!

  3. #3
    Registered User
    Join Date
    09-23-2014
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    28

    Re: Password is displaying instead of dots

    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.

  4. #4
    Forum Contributor
    Join Date
    01-31-2007
    Location
    Aschaffenburg, Germany
    MS-Off Ver
    Office 2013
    Posts
    104

    Re: Password is displaying instead of dots

    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.

  5. #5
    Registered User
    Join Date
    09-23-2014
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    28

    Re: Password is displaying instead of dots

    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.

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Password is displaying instead of dots

    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

  7. #7
    Registered User
    Join Date
    09-23-2014
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    28

    Re: Password is displaying instead of dots

    Sorry, I am fairly new to forums and their rules.

    Does this meet the criteria?

    Please Login or Register  to view this content.

  8. #8
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Password is displaying instead of dots

    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

  9. #9
    Registered User
    Join Date
    09-23-2014
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    28

    Re: Password is displaying instead of dots

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dots between numbers
    By Ondin in forum Excel General
    Replies: 3
    Last Post: 06-22-2010, 12:41 PM
  2. Columns with dots In Between
    By thantos in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-05-2009, 02:54 PM
  3. trailing dots
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 06-26-2007, 09:00 PM
  4. Dots missing
    By jiser in forum Excel General
    Replies: 9
    Last Post: 11-24-2005, 05:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1