tags:

views:

20

answers:

1

Hi,

I have a team of 10 persons who work on word documents, they format them as per our defined guidlines. To complete the work fast we have created a macro that has been updated on all the machines. This macro corrects the font, size and formatting.

How can I ensure and implement that nobody can change/replace or delete this macro from their system? In case this happens I should get an alert.

Can something be done at the system or programme level?

Thanks, PK

A: 

To ensure that no-one changes it, you can set a password on the macro. This page should get you there. But that won't help with notifying you.

Kinopiko
But even though it is protected with password, but any user might replace it with another macro with same name or delete this. How this can be avoided?