View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Martin Fishlock Martin Fishlock is offline
external usenet poster
 
Posts: 694
Default VBA code in Excel

In the VBA editor open Tools|VBA Project Properties... and select the
protection tab and set as desired.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"danh" wrote:

I have been writing a VBA code called Auto_Open which runs as I open my excel
document. I would like to hide this code with a password so that other
people do not see it or edit it. How do I hide this with a password?

Thank you
Danielle