Can I password protect Excel VBA / Macros?

[Guest]

I've seen it done before but can't find this option.

I just want to protect my VBA from prying eyes without putting a password on
the entire file and protecting each sheet.

Any help would be great!

Thanks,
Mike

 

[Bob Phillips]

Mike,

In the VBE project explorer window, select your project. Then right click,
and select Properties. There is a Protection tab to do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Paul B]

Mike,
To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in the left hand window right click on your
workbook name and select VBA project properties, protection, check lock
project for viewing and set a password. Press Alt and Q to close this window
and go back to your workbook and save and close the file. Be aware that this
password can be broken by third party software
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213903
XL2000: How to Help Protect Visual Basic Code in Excel