The macro cannot be found or has been disabled - after creating own macros in Word 2010

I create my own little macros in Word 2010 (WIndows 7) to do certain simple repetitive tasks such as replacing or formatting things in documents that I am working on.

When I used Word 2007, all these macros worked all the time, no problem. When I switched to Word 2010, I recreated the macros from scratch. But some of them throw up the above error message when I try to run them. Others work fine. I recorded them all in the same way so I can't understand why some run and others are blocked.

I have set Enable all macros in the Trust Center as described in the help link on the error message. I have then even re-recorded the macros that didn't work. But still they don't work.

This is really annoying. How do I get Word 2010 to run my macros every time?

NB: I have looked at other similar threads here but the scenario is different. I don't get an error message when I open Word, only when I try and run the macro concerned.

Many thanks for suggestions.

First, do not enable all macros. That is asking for trouble. It is OK as a temporary measure but you should not leave this setting turned on.

I assume they are stored in your NewMacros module in Normal.dotm. Is this correct?

Volunteering to "pay forward" the help I've received in the Microsoft user community.

Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com

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.

Thanks for your reply, Charles. It was set to Disable all macros with notification, I enabled all just to see whether they worked.

I just checked in View Macros to see where they are. The ones that don't work don't appear under 'All active templates and documents' or 'Normal.dotm'. Obviously the one that does work is listed under Normal.dotm.

I have just re-recorded one of the macros that doesn't work, and made sure it was set to store the macro to Normal.dotm. I then restarted Word and checked View Macros, but the new macro I just recorded does not appear under either 'All active templates and documents' or 'Normal.dotm'.

Kari

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.

Hi Kari,

When in Word press Alt+F11 to see the VBA editor.

In that, on the right, you should see Normal. If there is a little + to the left, click on that to expand. NewMacros should be the place where your macros are located.

This is a key skill set for anyone serious about using macros.

Recorded macros are seldom ideal. There are many things that the macro recorder simply will not notice and record.

If you open an old copy of your normal.dotm from Word 2007, you should see the macros there. You can copy those into a module in your current Word 2010 normal.dotm.

I generally do not store macros I use in normal.dotm but in a separate Add-In or Global template. This is a bit more trouble, but it gives much more flexibility and means that if something "happens" to my normal.dotm, I haven't lost my work.

Try putting your macros in an Add-In and see if that helps. An Add-In can be any template stored in the Word Startup Folder.

You shouldn't have to do this. I don't know where to start with diagnosing what is going on with your system but I suspect you have a (.com) Add-In that is blocking you from saving changes to normal.dotm.

Volunteering to "pay forward" the help I've received in the Microsoft user community.

Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com

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.

Hi Charles,

This is very useful, thanks. 

There is nothing under Normal/Modules/NewMacros at all, not even the one that does work.

I do have a couple of add-ins so I might try disabling those and testing the macros or re-recording them.

The macros I record are for straightforward functions like search and replace that I've been creating for years - since Windows 3.1 - and they have always worked up to now. I guess this is down to incompatibility with an add-in. Sadly I'm not sure whether I can locate my Windows 2007 normal.dotm on this particular machine or in my cloud.

Thanks again for your help and suggestions!

Kari

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 October 5, 2021 Views 1,986 Applies to: