MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protecting VBA code!!!


Posted by Duane Kennerson on May 23, 2001 3:47 PM

I know this has been asked before, I just can't find it.

How can I protect my VBA code to keep other users from
stealing it!!! (or seeing it)


Posted by Dave Hawley on May 23, 2001 4:04 PM

Hi Duane

While in the VBE go to Tools>VBAProject ProjectProperties-Protection. After adding the password, Save and close the file then re-open.

Dave
OzGrid Business Applications

Posted by Duane Kennerson on May 23, 2001 5:06 PM

Thanks Dave