View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Hide Macro Password Characters

Hi Jacob

It can only be done in an userform.

Create an userform with a Textbox and two buttons ( OK/Cancel). Select
the Textbox and open the Properties window (F4) and find the
PasswordChar property and enter * in the filed next to it.

Hopes this helps.
....
Per

On 20 Aug., 02:04, Morgimo wrote:
I have the following code:

If InputBox("To run update, please enter the password:") < "password" Then
Exit Sub

What is the code to get the password to display as ******** as they type?

Thanks,
Jacob