How can you hide the macros ?

[Josee Lapointe]

How can you avoid user to look at your macros by
choosing "Visual basic editor" ?
Is there a code too protect modules, hide them ?

 

[Paul B]

Josee, you can protect the 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
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **