Disabling Macro

  • Thread starter Thread starter John
  • Start date Start date
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.
 
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 **
 
Back
Top