passwordchar
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: passwordchar

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Leicestershire, U K
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    this is so so simple and yet I cannot apply it. Can anyone help.

    I have a password routine that auto unprotects my sheets in the workbook.

    There is an input box that requires the password, but will display said password.

    My wish is to hide the typing.

    The books etc do not appear to be clear on syntax for spreadsheets.

    Does anyone have an example of usage.

    Thanks.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Keith,

    Are you using an inputbox or a userform? You can't hide the password in an inputbox but you can with a userform. You can set the PasswordChar property of a textbox to whatever you like so you'll get ******** rather than seeing what's been typed in.

    HTH,
    D

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Leicestershire, U K
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I am using an inputbox.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com