View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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