Restricting Access to VB Code (xl98)

[MoonWeazel]

Hi All,

I am hoping someone will be able to help me!

I have a macro and I want to password protect/restrict access to the VB
within the macro.

I have had a look in the help files and come up with zip!

Has anyone got any ideas?

Thanks in advance!

MoonWeazel

 

[BrianB]

Have a look in MS Access Help under "Security". There is the possibilit
of setting levels of access for different users but I have never gon
that far.

You can set the module Hidden property by selecting the module icon an
then via the Property icon

 

[Tom Ogilvy]

in the vbe, make your project the active project, then Tools=>"project name"
properties, select the protection tab, select lock for viewing and set a
password.

You have to save the workbook for this to take effect I believe (perhaps
close it and open it again).

 

[Owen]

Mr. MoonWeazel sir,

Try Password protecting you VB. Within the Visual Basic
Editor, goto Tools:VBA Project Properties ... Protection:
Enter your Password

HTH
Owen