password protected macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to allow a user to run a macro but not allow the user to view
the macro code unless they know the password.

Thanks
 
Alt+ F11 to open VBA editor then Tools - VBA project properties - protection
and lock project for viewing and apply a password will do what you require.

Mike
 
That's it Mike, cheers for that

Mike said:
Alt+ F11 to open VBA editor then Tools - VBA project properties - protection
and lock project for viewing and apply a password will do what you require.

Mike
Click to expand...
 
You should always be aware that the password is no problem for experienced
users to crack.
 
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

Run Macros in a Password-protected workbook? 1
2003 Macro in a 2007 World 1
2003 Macro in Excel 2007 1
modify macro to include more tabs 1
Password protection in macro ( Anybody can view my password in VB 2
Password Protection 6
Macro- not re-password protecting 1
Macro to allow auto filter after running password protect 1

Back
Top