Hiding Macros?

[nebb]

I have an excel program that has a number of macros. I would like t
give the program to a friend and would like him to have the ability t
use the macros but not the ability to see or read the macros. Is thi
possible? I am working with Microsoft Excel 2000

 

[Paul B]

nebb, protect your VBA project. 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 & 2003
** remove news from my email address to reply by email **