Protecting or Hiding VBa Code In a Workbook
 

I have a workbook with a lot of VBa code which is distributed to data
inputers. Although the workbook and worksheets are protected, the VBa code
is not. I tried using the VBa properties to assign a password. This does
not seem to accomplish anything.

I don't need a high level of security with the code, but right now any user
can go in and change it.

Any assistance will be appreciated.

Protecting or Hiding VBa Code In a Workbook
 

Make sure you Lock project for viewing, too

(also on that tools|vbaproject properties|protection tab)

JR_06062005 wrote:

I have a workbook with a lot of VBa code which is distributed to data
inputers. Although the workbook and worksheets are protected, the VBa code
is not. I tried using the VBa properties to assign a password. This does
not seem to accomplish anything.

I don't need a high level of security with the code, but right now any user
can go in and change it.

Any assistance will be appreciated.

--

Dave Peterson