View Single Post
 
Old 05-27-2018, 01:26 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote