How do I protect Visual Basic for Application Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
However, you should recognize that there are ways to disable this
protection in a matter of seconds, including inexpensive commercial
crackers.
 
Thanks to both replies

Zagrijs

JE McGimpsey said:
However, you should recognize that there are ways to disable this
protection in a matter of seconds, including inexpensive commercial
crackers.
Click to expand...
 
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!
 
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!
Click to expand...

Launch the VB Editor.

Right-click the module and select properties.

There's a password field to prevent viewing.

MP-
 
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 :-)
------------------------------­------------------------------­----------------
 
Back
Top