View Single Post
 
Old 09-30-2020, 12:09 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

Putting macros into a template in Sharepoint is not usually a good idea. If your company has any level of IT security they will have disabled macros from http sources so the macros will be disabled.

Word templates are not well suited to life in Sharepoint. It is a reasonable place to store documents or templates that can be downloaded to a hard drive but not so good for 'working' dotx or dotm templates. Working templates need to be on your hard drive or a mapped network drive. Sharepoint can be a repository for saving them but if you want them to 'work' like Microsoft intended, they need to be saved outside of Sharepoint to enable that functionality.

If there is no automation (macros) required, I would save the file as docx and put it in a Sharepoint folder where users only have READ access. They can pick up the latest version from there and will be forced to save it locally or on a different Sharepoint location if they want to change it.

If you need macros with it, the dotm template containing the code should be saved to the user's User Templates or Workgroup Templates location by your IT group. You can then either ignore Sharepoint or put a docx file (with the dotm template attached) into your Sharepoint location where your users know where to get it.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote