PDA

View Full Version : Solved: locking VBA project



Anomandaris
11-16-2009, 04:28 AM
HI,

Im trying to lock the vba project page so that no one can see the macros.
I went to 'Properties' and selected the Lock option entered my own password , but it doesnt work

I can still see the macros in the VBA prohject page

im sure this is quite basic

please advise

thanks

Bob Phillips
11-16-2009, 04:45 AM
Put the line

Option Private Module

at the start of your code modules.

Anomandaris
11-16-2009, 05:50 AM
I tried that , it doesnt work though

Bob Phillips
11-16-2009, 06:42 AM
\whast's the password.

Anomandaris
11-16-2009, 07:46 AM
its 'jobs'

bizarre, it seems to be working

Anomandaris
11-16-2009, 07:48 AM
thanks xld!