I have a macro in a file; this file is dedicated to providing macros. This file is kept in the Word STARTUP folder so it is loaded but not visible every time Word starts. Several Quick Access Toolbar (QAT) buttons are bound to macros in this file.
I have added two Ribbon buttons to run macros in this file. At first, it worked fine. Now the buttons do not do anything. I cannot think of anything that changed since I installed the buttons. I have put checkpoints in the code and the Subs are not being invoked. If I open the file and then look at the code (you must have the file open to be able to edit the code, even though the file appears in the VBA window when it's not opened) I can run the code using F5, so this does not appear to be a macro security issue. I can click other buttons on the QAT that successfully run macros in the same file.
I have sometimes experienced buttons that get disconnected from their macros, so I tried re-adding buttons, but the new buttons do not work either. I tried adding a button to the QAT but that doesn't work either.
What can cause a button to fail to activate a macro when the macro can be run using F5 in the code?
Bookmarks