Run macros when document opens

[THH4929]

Hi all,




is there a way to enable macros to run on a work doc, i.e., to update all bookmarks, without having click the enable button?


The reason behind my question is that i'm creating new documents that I want to be able to send to all staff/clients, that requests user input via input boxes to update bookmarks in the document, for example, client form, that requests users to input critial information requirements.


If not, no worries, just looking for a more professional look from a clietns perspective.


Many thanks

[macropod]

Yes - add the macros to the document's template and drive them via a Document_Open macro in the template's 'ThisDocument' code module or via an AutoOpen macro in a normal code module.

[Guessed]

Macros can be enabled automatically in several ways. The two easiest ways are:
- You can trust a folder containing the file where your macros are. Check File > Options > Trust Center > Trust Center Settings > Trusted Locations
- If you don't have rights to change this (because your IT guys don't trust you) then an alternative is to put the template into your User Templates folder location which is automatically trusted. By default, this folder is located in %appdata%\Microsoft\Templates

If you are sending files to external clients, then having them do something like this is very unlikely so you need to examine whether there is a non-macro alternative to what you are trying to achieve and whether its worth asking them to install templates to these trusted locations. I would be exploring whether a form with linked Content Controls might work better as a way of getting user inputs.