How do I protect Visual Basic for Application Code

[Zagrijs Venter]

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]

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.

 

[JE McGimpsey]

However, you should recognize that there are ways to disable this
protection in a matter of seconds, including inexpensive commercial
crackers.

 

[Zagrijs Venter]

Thanks to both replies

Zagrijs

However, you should recognize that there are ways to disable this
protection in a matter of seconds, including inexpensive commercial
crackers.

 

[ZsO]

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!

 

[Mangus Pyke]

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-

 

[Ken Wright]

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
------------------------------­------------------------------­----------------