Solved: locking VBA project

[Anomandaris]

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]

Put the line

Option Private Module

at the start of your code modules.

[Anomandaris]

I tried that , it doesnt work though

[Bob Phillips]

\whast's the password.

[Anomandaris]

its 'jobs'

bizarre, it seems to be working

[Anomandaris]

thanks xld!