How to prevent other users from seeing and changing your VBA code

Article contributed by Jonathan West

In the VBA editor, right-click on the project name in the project window on the left, and select “TemplateProject properties” from the pop-up menu. The name might vary depending on whether you have renamed your project, but it will be the properties item you want.

Select the protection tab, set the “Lock Project for viewing” checkbox, and enter a password twice, in the two boxes available.

Unless you are absolutely sure you can't possibly forget the password, only do this to a copy of your template, and keep the original unlocked.