masking password characters

P5X · Feb 20th, 2002, 12:17 PM

Can this be done without using a userform?
I am just using an input box to check the password, as follows:

Password = InputBox("Enter the password")
If Password = "password" Then
Sheets("staff_menu").Select
Else...

Thanks

dk · Feb 20th, 2002, 12:23 PM

It may be possible to do this by hooking to the inputbox - although I doubt it. If it is then the amount of code and the complexity of it (lots of Windows API calls) would make a userform a far easier solution.

Regards,
D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 12:17 PM	#1
P5X New Member Join Date: Feb 2002 Posts: 18	Can this be done without using a userform? I am just using an input box to check the password, as follows: Password = InputBox("Enter the password") If Password = "password" Then Sheets("staff_menu").Select Else... Thanks

Feb 20th, 2002, 12:23 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	It may be possible to do this by hooking to the inputbox - although I doubt it. If it is then the amount of code and the complexity of it (lots of Windows API calls) would make a userform a far easier solution. Regards, D