View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.