Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
restricting access using a macro | Excel Worksheet Functions | |||
Restricting Access to Parts of worksheet | Excel Worksheet Functions | |||
restricting access to a worksheet? | Excel Discussion (Misc queries) | |||
Restricting access to workbook | Excel Programming | |||
restricting access to workbook | Excel Programming |