Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting (hiding) the Code in an Add-in
I have a number of add-ins that I need to protect.
One (which is used in house) is nicely "locked" up. Requires a pass-word, no matter how I try to expand it ( double clicking, or clicking on the plus sign) As far as I can figure, I used the same steps on the Add-in that I need to send out Internationally. No matter what I try, I cannot block the access to it. I go to VBAProject Properties Select Protection Enter Pass-word and Pass-word Confirmation Save the add-in Then, when I go to check if it is locked, it just opens up again. Please help JFS -- John F. Scholten |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting (hiding) the Code in an Add-in
If you are distributing an ADD-IN, you should rename it to something besides
VBAProject. You can do this in the properties for the project. Then you will see VBAProject_Name Properties when you go to the menu so you know you are protecting the correct workbook Also, you need to make sure you have saved the correct project if doing it from the vbe. Hitting the save button doesn't always work. I usually use the immediate window and do Workbooks("MyProject.xls").Save to be absolutely sure. There isn't any other way to protect your code - nor have I seen another post complaining that it doesn't work, so I suspect you are not assigning the password to the correct project. -- Regards, Tom Ogilvy "John F" wrote in message ... I have a number of add-ins that I need to protect. One (which is used in house) is nicely "locked" up. Requires a pass-word, no matter how I try to expand it ( double clicking, or clicking on the plus sign) As far as I can figure, I used the same steps on the Add-in that I need to send out Internationally. No matter what I try, I cannot block the access to it. I go to VBAProject Properties Select Protection Enter Pass-word and Pass-word Confirmation Save the add-in Then, when I go to check if it is locked, it just opens up again. Please help JFS -- John F. Scholten |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting and Hiding formulas | New Users to Excel | |||
Protecting / Hiding the Code | Excel Programming | |||
Protecting buttons with VB code rather than protecting sheets/books? | Excel Programming | |||
Hiding/Protecting the code of macro | Excel Programming | |||
Hiding/Protecting vb code in excel | Excel Programming |