[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

VBA code in Excel

DanH

12/18/2006 7:29:00 AM

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
2 Answers

Martin Fishlock

12/18/2006 8:11:00 AM

0

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

DanH

12/18/2006 10:27:00 AM

0

Thanks for your help.

"Martin Fishlock" wrote:

> 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