password protect a macro

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

i have a sheet with a button which executes a macro, i would like t
make it so that you can only run the macro (clcik the button) if yo
supply the correct password
thanks

robert
 
Add the line

If inputbox("Please Enter Password") <> "PASSWORD" then end

Dunca
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting a macro 4
Macro to allow auto filter after running password protect 1
Password protection in macro ( Anybody can view my password in VB 2
Run Macros in a Password-protected workbook? 1
how to record macro for passwords 5
Protection on Worksheets 5
Qualifying permissions in protect unprotect macro. 3
macro protection 4

Back
Top