May 29 2023 01:22 PM
I have macros that I am unable to run in all documents. This started to occur a few days ago. Before that, no problem. I can create a macro in one document, but am unable to use it in any other document.
May 29 2023 01:47 PM
May 29 2023 05:36 PM
When you record the macro, you can specify the location, which will be the default (Normal.dotm template), the active document, or that document's template.
You may have something that is blocking saving your normal template. Some Add-Ins do this. If in a corporate environment, your normal template may be locked diown or protected.
-
Use the vbe editor (Alt+F11/Opt+F11 Mac) to look at your NewMacros module in your Normal project. If you see your macro there, while in the vbe editor, press Ctrl+S to save your Normal template.
You can also create and keep macros in one or more global templates.
Resources:
You can move your macros to a different spot.
Jun 04 2023 01:58 PM