Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Protection
I don't want just any old user to have access to macros. How can I prevent
user access to macros. I can't share the workbook because I have seen problems with that. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Protection
Mike,
There is no secure way of protecting code in a workbook. Mike "Mike H." wrote: I don't want just any old user to have access to macros. How can I prevent user access to macros. I can't share the workbook because I have seen problems with that. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Protection
Depends on your definition of secure really. If its just to stop
average Joe Bloggs at work from getting access to your code, open up the code editor, select tools - vba project properties - protection tab, and lock the project for viewing and set the password. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Protection
In the VBA IDE, goto ToolsVBA Project PropertiesProtection and check the
"Lock project for viewing, and optional enter a password. Also, depending on you intentions, look into "Option Private Module" and possibly use an Add-In. NickHK "Mike H" wrote in message ... Mike, There is no secure way of protecting code in a workbook. Mike "Mike H." wrote: I don't want just any old user to have access to macros. How can I prevent user access to macros. I can't share the workbook because I have seen problems with that. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Protection
My definition of secure is to prevent average Joe Bloggs at work from getting
into the code and messing it up. This is exactly what I want! Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code and Protection Sheet | Excel Programming | |||
Put Password Protection in Code | Excel Discussion (Misc queries) | |||
Timebomb protection of Code | Excel Programming | |||
vba code protection | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |