Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I protect Visual Basic for Application Code
I have noticed that MS's templates and other Excel files received from other
sources needs a password to open the VBA source code. I have been unable to find any assistance from OLH or figure it out on m,y own how to protect my VBA source code. Any help appreciated. |
#2
|
|||
|
|||
Open excel
open your workbook hit alt-f11 (to get to the vbe) hit ctrl-r (to see the project explorer) with your project selected in the project explorer Tools VBAProject Properties Protection tab. Zagrijs Venter wrote: I have noticed that MS's templates and other Excel files received from other sources needs a password to open the VBA source code. I have been unable to find any assistance from OLH or figure it out on m,y own how to protect my VBA source code. Any help appreciated. -- Dave Peterson |
#3
|
|||
|
|||
However, you should recognize that there are ways to disable this
protection in a matter of seconds, including inexpensive commercial crackers. In article , Dave Peterson wrote: Open excel open your workbook hit alt-f11 (to get to the vbe) hit ctrl-r (to see the project explorer) with your project selected in the project explorer Tools VBAProject Properties Protection tab. |
#4
|
|||
|
|||
Thanks to both replies
Zagrijs "JE McGimpsey" wrote: However, you should recognize that there are ways to disable this protection in a matter of seconds, including inexpensive commercial crackers. In article , Dave Peterson wrote: Open excel open your workbook hit alt-f11 (to get to the vbe) hit ctrl-r (to see the project explorer) with your project selected in the project explorer Tools VBAProject Properties Protection tab. |
#5
|
|||
|
|||
Hi,
Is there any way to really protect my work (VBA code)? I am also interested in protect my MS Excel VBA work under Mac OS X! Thank you for any help! "JE McGimpsey" wrote: However, you should recognize that there are ways to disable this protection in a matter of seconds, including inexpensive commercial crackers. In article , Dave Peterson wrote: Open excel open your workbook hit alt-f11 (to get to the vbe) hit ctrl-r (to see the project explorer) with your project selected in the project explorer Tools VBAProject Properties Protection tab. |
#6
|
|||
|
|||
On Wed, 3 Aug 2005 08:26:12 -0700, ZsO wrote:
Is there any way to really protect my work (VBA code)? I am also interested in protect my MS Excel VBA work under Mac OS X! Launch the VB Editor. Right-click the module and select properties. There's a password field to prevent viewing. MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#7
|
|||
|
|||
But that can be bypassed if you know how, so don't necessarily rely on it to
protect the crown jewels. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Mangus Pyke" wrote in message ... On Wed, 3 Aug 2005 08:26:12 -0700, ZsO wrote: Is there any way to really protect my work (VBA code)? I am also interested in protect my MS Excel VBA work under Mac OS X! Launch the VB Editor. Right-click the module and select properties. There's a password field to prevent viewing. MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Trust access to visual basic project greyed out | Excel Discussion (Misc queries) | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Visual Basic Error Message | Excel Discussion (Misc queries) | |||
Visual Basic Code Remains in "memory" | Excel Worksheet Functions |