Disabling Macro

J

John

Hi all,
I want to disable other users of an excel file from
accessing the macro (programming codes), unless that
person has a password to access to it. Can I do that in
Excel97, SP2?

Thanks for any suggestion.

regards,
John.
 
P

Paul B

John, do you not want them to see the code? if so right click on your vba
project and select vba project properties, protection check lock for viewing
and set a password

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Top