I have a custom button in Excel which runs a macro. Can I pasword protect the button so that it asks for a password before running the macro and if so how do I do this. Thanks
mPass = inputbox("Please enter password to run macro"
if mPass <> "Password" then
msgbox "Incorrect password"
exit sub
else
end if
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.