Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Using a macro for a user-entry password - hiding the entry

Is there a good way to hide the password entry when it is entered by a
user?

I have written a program which requires a password to make changes.
However, when a password is entered (example: XxBNB77T), the pass
word appears instead of **********.

Is there anyway to hide the password when it is being entered.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Using a macro for a user-entry password - hiding the entry

Set up a userform, where user can enter the password in a TextBox. Use
* as PasswordChar in the Textbox properties.

Hopes this helps.
....
Per

On 8 Mar., 02:56, Eddie Kirby wrote:
Is there a good way to hide the password entry when it is entered by a
user?

I have written a program which requires a password to make changes.
However, when a password is entered (example: *XxBNB77T), the pass
word appears instead of **********.

Is there anyway to hide the password when it is being entered.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Using a macro for a user-entry password - hiding the entry

You can use a textbox on a userform to get the info. The textbox has a
..PasswordChar property that can be used to hide the real password.

Eddie Kirby wrote:

Is there a good way to hide the password entry when it is entered by a
user?

I have written a program which requires a password to make changes.
However, when a password is entered (example: XxBNB77T), the pass
word appears instead of **********.

Is there anyway to hide the password when it is being entered.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting which macro to run based on a user entry [email protected] Excel Programming 3 October 31st 07 09:10 AM
sql server password entry during macro run Carl Irving Excel Discussion (Misc queries) 0 October 23rd 07 05:22 PM
Hiding/Exposing Worksheets based on a Number Entry David Excel Discussion (Misc queries) 6 December 11th 05 02:40 AM
Comparing password entry vs stored password - 2003 L Mehl Excel Programming 3 November 19th 04 05:52 PM
Password Entry Diane Mallin[_2_] Excel Programming 1 August 3rd 04 06:20 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"