password protected macro

M

mcphc

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
 
M

Mike

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
 
M

mcphc

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
 
D

Don Guillett

You should always be aware that the password is no problem for experienced
users to crack.
 
Top