excel - can all the macros be protected?

A

arunjoshi

can all the macros be protected, so that a user (other than I) canno
see or edit the macros
 
P

Paul B

arunjoshi, 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 2000 & 97
** remove news from my email address to reply by email **
 
J

JE McGimpsey

In the VBE, choose Tools/<project> properties. In the Protection tab of
the properties dialog, check the Lock project for viewing checkbox and
enter a password.

Note that this protection is extremely weak. There are commercial
crackers available that will remove it in a second or two.
 
Top