making macros uneditable by others

M

Mark Tangard

In the Visual Basic Editor with the project open, click
Tools-> [name of project] Properties, Protection tab,
check 'Lock for viewing'...
 
J

Jay Freedman

Loui said:
How to I make macros I have written uneditable by others?

In the VBA editor, go to Tools > Project Properties. On the Protection tab,
check the "Lock project for viewing" box and enter a password.

A bit of advice: Keep a copy of the template that you don't distribute to
anyone else, and don't password-protect that copy. Sure as anything, if you
don't do this you will forget/lose the password and not be able to open your
own project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top