Restricting Access to VB Code (xl98)

  • Thread starter Thread starter MoonWeazel
  • Start date Start date
M

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
 
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
 
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).
 
Mr. MoonWeazel sir,

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

HTH
Owen
 
Back
Top