Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a code with password to avoid mishandling
Hi,
I have wriyyen a VBAcode in Excel Now i want the the code to be protected nor to be seen by others to avoid mishandling, as my worksheet is a shred one. help me how to protect the code. Regards Bobby. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a code with password to avoid mishandling
Goto to the VB editor (Alt-F11), then in the "Project Explorer" Window (if
it is not visible then choose View-Project Explorer from the main menu) click on the VBA Project heading for the workbook code you wish to protect and right click, choose VBA Project Properties. In the project properties dialog choose protection and set the password etc. Next time you open the workbook you cannot view the code without the password. NOTE: This is not a totally secure method but will stop most tampering. -- Cheers Nigel "bobby" wrote in message oups.com... Hi, I have wriyyen a VBAcode in Excel Now i want the the code to be protected nor to be seen by others to avoid mishandling, as my worksheet is a shred one. help me how to protect the code. Regards Bobby. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a code with password to avoid mishandling
Hi Nigel,
Thankyou for the answer. Thanks and Regards Bobby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
password protect project with VBA code | Excel Programming | |||
password protect vba code | Excel Discussion (Misc queries) | |||
password protect vba code | Excel Programming | |||
password protect vba code | Excel Programming | |||
Password protect excel code | Excel Programming |