I want to distribute a template with its macros, but don't want users to be able to see the macros in the documents which are based on the template (so they won't be able to modify or copy my work). Is this possible, and if so, how?

Thanks!

[email protected]

Larry Landis
Technical Writer

Hi,

You can protect your vba code by setting the password.

Open your template (.dot file) in word.

To set the password, open the vba editor by pressing Alt + F11;
Goto Tools -> [project Name] properties
here the project name will be the your project name.

it will open a project properties window there will be two tabs General and protection.

Goto protection tab,

Check the option "Lock project for viewing"
 and
Enter your desire password

Regards,

CS.