I found a Very useful macro so i added it to several that i want to create an add in for. I have the add in created and it works when i transfer to other computers. Now i want to make a custom ribbon. I can't figure out how to activate a macro with a button. Running the macro using the developer tab, has no error. assigning the macro to a button on the "QAT" works also. I am using the "Custom UI Editor" to create the Ribbon, everything "works" until it gets to the macro. "Wrong number of arguments or invalid property assignment" appears. I may have to change something in the code, but being a NOOB, i can't figure it out.
XML code for ribbon
This is the recorded Macro Code for: Module1![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks