Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open & Macro
Not precisely sure what level of protection you are interested in, but in
the VBA editor, if you select Tools | VBA Project Properties | Protection there is a field labeled "Password to view project properties" that may give you what you need. Without the password, the user cannot open up and view any of the code in the workbook. Do be aware however that such passwords can be cracked pretty easy. If all you want is to keep the causual user from messing up your code, it works pretty well.... James "Metallo" wrote in message ... Hi, I did create the Workbook_Open code to protect the sheets in my WB and at the same time to guarantee the outlining function to work, the Macro allows a change of formatting, therefore, I put the Workbook_Open code on top and bottom of the Macro in order to let it work properly. My next problem is that I have to give the WB to other users, therefore I need to apply a Password to both the Workbook_Open code and, as a result, in the Macro. How do I make them invisible in both WB_Open and Macro? If I add the password, a user with a minimum of knowledge, jcam just click ALT+F11 and he gets the password. Thank you Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open macro not running | Excel Discussion (Misc queries) | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
Workbook_Open | Excel Programming | |||
Help with Workbook_Open | Excel Programming | |||
Workbook_Open macro created in Excel 97 problems on MAC | Excel Programming |