Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password feature in command buttons
Hi
I would like to incorporate a password utility in my command button. The purpose is to allow only authorized users to activate the macro. I was thinking of a MsgBox to popup and ask the user to enter a password and, if correct, the macro will activate otherwise nothing should happen. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password feature in command buttons
Sub test()
If InputBox("Password:") < "Brilliant" Then Exit Sub MsgBox "Code is running fine", vbInformation End Sub -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please "Marvin Moore" skrev i melding ... Hi I would like to incorporate a password utility in my command button. The purpose is to allow only authorized users to activate the macro. I was thinking of a MsgBox to popup and ask the user to enter a password and, if correct, the macro will activate otherwise nothing should happen. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Can the Undo feature and/or command be turned off??? | Excel Discussion (Misc queries) | |||
Help with command buttons | Excel Worksheet Functions | |||
command buttons | Excel Worksheet Functions |