Hi,

I am using the code as below to password protect the use of a macro. Do you know how I can change it to show "****" instead of "password" when the user is typing it in??

Sub test()
Dim pw As String
pw = InputBox("Please enter password")
If pw <> Format(Now(), "ddmmyyyy") Then
    MsgBox "Invalid password"
    Exit Sub
Else
    MsgBox "success"
End If

End Sub
Merci,

Adam