J jason2885 Registered User. Local time Yesterday, 23:27 Joined Jun 18, 2007 Messages 99 Jul 26, 2007 #1 I have a button in a form that runs a macro. I need to somehow password protect that button. How could I go about doing that.
I have a button in a form that runs a macro. I need to somehow password protect that button. How could I go about doing that.
pbaldy Wino Moderator Staff member Local time Yesterday, 23:27 Joined Aug 30, 2003 Messages 36,272 Jul 26, 2007 #2 One way: Code: If InputBox(...) = "password" Then 'run macro Else Msgbox "Wrong password" End If See VBA Help for more info on InputBox if needed.
One way: Code: If InputBox(...) = "password" Then 'run macro Else Msgbox "Wrong password" End If See VBA Help for more info on InputBox if needed.