Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Protection
Hi, I want to protect my macros so noone can change them. I have tried using
the VBA Editor, Tools menu, VBA Project Properties, then the Protection tab and enter a password, but this doesn't work. Any ideas, I'm using 2007. Many thanks in advance V |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Protection
save and close your workbook.
Then reopen and test it. Vie wrote: Hi, I want to protect my macros so noone can change them. I have tried using the VBA Editor, Tools menu, VBA Project Properties, then the Protection tab and enter a password, but this doesn't work. Any ideas, I'm using 2007. Many thanks in advance V -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Protection
Thank you. Should have tried that, sorry.
V "Dave Peterson" wrote: save and close your workbook. Then reopen and test it. Vie wrote: Hi, I want to protect my macros so noone can change them. I have tried using the VBA Editor, Tools menu, VBA Project Properties, then the Protection tab and enter a password, but this doesn't work. Any ideas, I'm using 2007. Many thanks in advance V -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Protection
While the built-in protection for a VBA project works, it is very
weak. There are any number of password crackers available on the Internet that can break the password. I use VBAKey from Passware that will break the password in a matter of seconds. VBA's security is not adequate for protecting proprietary data or code with intellectual property value. For that level of protection, you should create a COM add-in with VB6 or VBNET or C#. With a COM add-in, only the compiled code is distributed to the user --- source code is never distributed., Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com The San Diego Project Group, LLC (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Thu, 25 Sep 2008 06:32:00 -0700, Vie wrote: Thank you. Should have tried that, sorry. V "Dave Peterson" wrote: save and close your workbook. Then reopen and test it. Vie wrote: Hi, I want to protect my macros so noone can change them. I have tried using the VBA Editor, Tools menu, VBA Project Properties, then the Protection tab and enter a password, but this doesn't work. Any ideas, I'm using 2007. Many thanks in advance V -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Protection Macro | Excel Worksheet Functions | |||
Macro protection | Excel Programming | |||
Macro Protection | New Users to Excel | |||
Macro Protection | Excel Programming |