I created a Word macro-enabled template (.dotm) in Office 365. The DOTM contains 3 simple macros - AutoNew with message, AutoOpen with message, and a Userform with simple data entry code. The DOTM works as intended when loaded on my local computer's desktop and when accessed from OneDrive. That is, I can open for editing by right-clicking and selecting open and I can create an instance by double-clicking on the DOTM, which triggers the AutoNew macro. I am trying to achieve the same result in SharePoint Online.
I have a SharePoint Communication site with a Library. I uploaded the DOTM to the Library. When I right-click and select Open | Open in browser, no macro is triggered. Given the title (without any extension), I assume that the DOTM loaded and is presented with macros disabled. When I right-click from the Document list and select Open | Open in app, the AutoOpen macro is triggered and the DOTM is loaded. If I (left-)click on the file in the Document list (seems to activate on a single click), I receive a dialog box titled "Open Word?" If I click "Open Word", the AutoOpen macro is triggered and the DOTM is loaded - the same as when I right-clicked and selected Open in app. I assumed that accessing the file from the Document list in SharePoint would be the same as accessing in OneDrive (i.e., open instance with AutoNew macro triggered) but such does not appear to be the case.
Also, at the Document list, I clicked on the +New pull-down list, selected +Add template, and added the DOTM so that it now appears on the +New pull-down list. If I click on the DOTM in the +New pull-down list, I receive a blank page (titled "about:blank") and a new document titled "DOTM File.dotm" appears in the Document list. This is not what I seek either.
I would like to enable a user to click on the file and have an instance document load, triggering a (presumably AutoNew) macro that will contain a UserForm. However, neither including the DOTM on the Document list or adding the DOTM to the +New pull-down list appear to work.