View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Hiding / locking access to VBA code

You can protect it under Tools - VBA Project properties. I don't believe
I've heard of a way to break this password, so if you forget it, you're toast!
--
HTH,
Barb Reinhardt



"Roger on Excel" wrote:

I have a spreadsheet which relies heavily on VBA code. I want to hide access
to my proprietary code from users.

Is there a way to password protect access to the VBA ?

Can anyone help?

Thanks,

Roger