Module Protection
 

I have created a document and have it stored on a shared drive for many
people to access. Within this document I run a macro with a control button.
I have set the document properties to protect with a password, however this
does not work. Users can click on the + sign to view the modules and then
open them and see the code. Is there a way to lock this document down so
users can not get into my modules and edit the code. Thanks so much for your
help.

Module Protection
 

You can protect the code in VBA,. Goto ToolsProperties and select the
Protection tab.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SITCFanTN" wrote in message
...
I have created a document and have it stored on a shared drive for many
people to access. Within this document I run a macro with a control
button.
I have set the document properties to protect with a password, however
this
does not work. Users can click on the + sign to view the modules and then
open them and see the code. Is there a way to lock this document down so
users can not get into my modules and edit the code. Thanks so much for
your
help.