Restricting Access to VB Code (xl98)
 

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


---
Message posted from http://www.ExcelForum.com/

Restricting Access to VB Code (xl98)
 

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

--
Message posted from http://www.ExcelForum.com

Restricting Access to VB Code (xl98)
 

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).

--
Regards,
Tom Ogilvy

"MoonWeazel " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

Restricting Access to VB Code (xl98)
 

Mr. MoonWeazel sir,

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

HTH
Owen

-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.