password protected macro
 

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

password protected macro
 

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

"mcphc" wrote:

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

password protected macro
 

That's it Mike, cheers for that

"Mike" wrote:

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

"mcphc" wrote:

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

password protected macro
 

Your welcome and thanks for the feedback

"mcphc" wrote:

That's it Mike, cheers for that

"Mike" wrote:

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

"mcphc" wrote:

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

password protected macro
 

Cheers.. !!
Its helpes me too..

Boss

"mcphc" wrote:

That's it Mike, cheers for that

"Mike" wrote:

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

"mcphc" wrote:

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

password protected macro
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Boss" wrote in message
...
Cheers.. !!
Its helpes me too..

Boss

"mcphc" wrote:

That's it Mike, cheers for that

"Mike" wrote:

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

"mcphc" wrote:

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