How to prevent user export Word Micro?

[Lisa]

Hi,

We have a few micro written for Word. They are valuable for our company, but
everyone can export them and take home if they know how to do it. Is there
any way that just let user use them but they can not export/view them?

Any help will be appreciated!

Thanks in advance!

Lisa

 

[Jay Freedman]

Hi,

We have a few micro written for Word. They are valuable for our company, but
everyone can export them and take home if they know how to do it. Is there
any way that just let user use them but they can not export/view them?

Any help will be appreciated!

Thanks in advance!

Lisa

You can apply a password to the macro project. That will prevent
anyone who doesn't have the password from exporting or viewing the
code.

In the VBA editor, click the Tools menu and then the Project
Properties item (which may have the name of the template instead of
"Project"). In the dialog, click the Protection tab and enter the
password twice. Then save the template and close the editor.

Each time you click any module in the project to see the code, you'll
have to enter the password. Don't lose it! (It might be a good idea to
keep a copy of the template that does not have a password, in case you
need it; or export the project's modules and keep those files in a
safe place.)
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Lisa]

Hi Jay, thank you very much! it works.

You can apply a password to the macro project. That will prevent
anyone who doesn't have the password from exporting or viewing the
code.

In the VBA editor, click the Tools menu and then the Project
Properties item (which may have the name of the template instead of
"Project"). In the dialog, click the Protection tab and enter the
password twice. Then save the template and close the editor.

Each time you click any module in the project to see the code, you'll
have to enter the password. Don't lose it! (It might be a good idea to
keep a copy of the template that does not have a password, in case you
need it; or export the project's modules and keep those files in a
safe place.)
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Lisa]

Hi Jay,

If I enable the password protection, user can change the password if they
know how to do it since they have local admin privileges. Please advice!

Lisa

 

[Jay Freedman]

Local admin privileges have nothing to do with it. They have to know
the current password in order to open the project, but if they can
open it then they can change the password.