MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding VBA Code

Posted by Duncan on February 28, 2001 9:25 AM

Is there a way of protecting the code you have written so that a user cannot automatically access it??

Posted by William Kelly on February 28, 2001 9:42 AM

When you are in Visual Basic go to the "Tools" menu and then select <projectname>projectproperties (at the bottom of the menu). When you go in that there is a General and a Protection tab. Go into the Protection tab and click the box that says "Lock project for viewing", set the password, and close out of the project in order for it to take effect.