+ Reply to Thread
Results 1 to 3 of 3

Customize Ribbon Code. Need Help!

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    Ne/Ia
    MS-Off Ver
    office 2016
    Posts
    52

    Customize Ribbon Code. Need Help!

    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
    Please Login or Register  to view this content.
    This is the recorded Macro Code for: Module1
    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Customize Ribbon Code. Need Help!

    the callback you specify for the onAction parameter needs a specific declaration. change the first line of code to
    Please Login or Register  to view this content.
    note that the customui editor has a button to generate the callback procedure stubs for you
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    Ne/Ia
    MS-Off Ver
    office 2016
    Posts
    52

    Re: Customize Ribbon Code. Need Help!

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1