VBA code in Excel
 

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

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