How to make users enable macro before opening the file?

[elaineAda]

Hi Hi

Is there a macro that could 'force' users to enable macro before opening the file?



Thanks

[BrianHoard]

If you're referring to the warning that Office gives when opening a macro-enabled document, like docm or dotm, what we do is place the file in a trusted folder for the user. In our environment, that is in the user's STARTUP folder, at %APPDATA%\Roaming\Microsoft\Word\STARTUP
You can see what locations are trusted on your system by looking in your Trusted Locations. From Word, Options > Trust Center > Trust Center Settings > Trusted Locations

Does that help?

[elaineAda]

Hi BrianHoard
It didnt seem to work.
I have a turn around solution, it is to password protect the file, and user can only edit the file when user click on 'enable content.'
But the macro that i wrote cannot work perfectly.
Error message encountered when user save the file, and then close the file without saving the file. When user exit the file like that, the file was not save and became password unprotected.
When user try to access the file the next round, there is error message.
Is there anyway to go about this?

[elaineAda]

Originally Posted by elaineAda

Hi BrianHoard
It didnt seem to work.
I have a turn around solution, it is to password protect the file, and user can only edit the file when user click on 'enable content.'
But the macro that i wrote cannot work perfectly.
Error message encountered when user save the file, and then close the file without saving the file. When user exit the file like that, the file was not save and became password unprotected.
When user try to access the file the next round, there is error message.
Is there anyway to go about this?

Basically it is to unprotect a password protected document, then re protect upon closing. Appreciate help on this.

[gmayor]

If the aim is to allow the user to edit only part of the document, e.g. in your sample to add the name and address, you don't need a macro. You can use content content controls to accept the user input and add editors to the controls before protecting as read only and then the user can only edit the content control contents. See attached (the password is the same as your sample).
The easiest way to do this is to use Insert Content Control Add-In which includes the options to add editors and protect the document. It can be done without, but it is more fiddly to do so.