Ask a new question

Can't get Word 2013 macro-enabled template to work

Hi Guy's,

I have a macro-enabled template, .dotm, which includes a button on the Quick Access toolbar. Clicking this button runs a macro which saves the files to a location on the user's machine with a generated file name and also gives the user the option to open the folder where it is saved to.

The template was created in Word 2010 and is stored in Word's STARTUP folder for each user, C:\Users\username\AppData\Roaming\Microsoft\Word\STARTUP

all of whom are running Windows 7 professional with a mix of Office 2010 and Office 2013

There are no problems in Word 2010. However when opening a new document in Word 2013 the button appears on the Quick Access toolbar as expected but when clicked the message "The macro cannot be found or has been disabled because of your Macro security settings." is displayed.

I don't understand why this is as all the macros settings are fully enabled, plus

- startup folder being a trusted location

- Macro security set to "enable all macros"

- Template loaded and ticked in the Templates and Add-ins property window

- Protected view turned off

Does anyone have any ideas?

Office 2013 32 bit

Windows 7 64 bit

Libby x

Hi Guys,

I fixed the problem and will post it here as it may help someone else.

The problem was that the dotm template had references to my normal template which contains my macros.

To create the dotm template successfully I had to open Word

File/New/My templates

Then in the dialog choose Blank Document (macro enabled) and Choose Template.

The reference to Normal was then missing. 

I then added my macros and did Ctrl+S in the VBA editor and saved as a dotm.

I then added the button to the Quick Access Toolbar, specifying the dotm I'd just saved. If not already saved then only the "For all documents" is available.

I then did File/Save As to and overwrote as a dotm with the same name.

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 7, 2024 Views 3,824 Applies to: