Hello,
I have a Word 2010 Macro enabled document that contains two sets of ActiveX Command Buttons. One set of buttons performs a spell check on specific sections of the document and then prints those same sections. The other buttons add new pages to the document.
During the month of November, all the buttons worked perfectly. During December, Microsoft applied an MS Office Security Update (KB2553154) which disabled all of my AxtiveX Command Buttons. I have since learned at this site, thanks to Suzanne S. Barnhill , that Microsoft has created a workaround for this issue KB3025036 . Our IT staff has applied the workaround to the necessary PCs.
After applying the workaround fix, most of the command buttons work again, but some of them don’t. In researching the problem, I discovered that the (Name) Property for the buttons that are not working has been changed, thus when clicking on the button, the macro cannot be located because it has a different name than the button does.
For example, in one instance the original button (Name) was Print_Intake_Form, but the (Name) has now been changed to Print_Intake_Form1. In another instance, the original button (Name) was Print_Intake_Form, but the (Name) has now been changed to Print_Intake_Form11.
My idea for fixing this issue would be to create a macro that modifies the (Name) property for all the ActiveX buttons back to their original names. If that seems like the best way to fix the issue, what VBA code woudl be needed to perform such a task?
If that is not the best way to resolve the issue, I am open to suggestions.
Thank you
Mark