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.

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

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.

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.

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.

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

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