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.

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