+ Reply to Thread
Results 1 to 5 of 5

MS Office RibbonX

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    Excel 2007
    Posts
    22

    MS Office RibbonX

    Hi everyone,

    I want to programmatically call procedure, which is an callback for ribbonX control. I know, that there is control parameter dimensioned as IRibbonControl. I was thinnking, that I can simply create variable of this type and assigned it to the button on the ribbonX, but probably this could not be done

    Do you have any solution to the given problem?

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

    Re: MS Office RibbonX

    use a normal routine that is called by the callback and by your other code
    Josie

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

  3. #3
    Registered User
    Join Date
    08-10-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: MS Office RibbonX

    This is not applicable, as the XLA addin, which handles callbackes, is protected (yes, it's not an problem with Application.Run method), but the callback procedure reads value of control.id to do some stuff

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

    Re: MS Office RibbonX

    if the procedure needs a control id then it doesn't make sense to call it from anywhere else unless you simulate clicking the button. it is also useful if you explain the circumstance and restrictions when asking rather than dismissing suggestions

  5. #5
    Registered User
    Join Date
    08-10-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: MS Office RibbonX

    3rd party enterprise has provided my organization with set of addins loaded by each user at the excel instance linitalization. Functionality is accesible via ribbon (no API provided) I want to simulate clicking the controls as the foundation for my own API to provided addins.

    Do you know now, what I mean

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. References: RibbonX for 2007
    By Ada01 in forum Excel General
    Replies: 1
    Last Post: 01-18-2013, 04:33 AM
  2. [SOLVED] RibbonX Button
    By codeck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 04:36 AM
  3. Populate sheet names in RibbonX dynamic dropdown
    By 2Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2011, 04:51 PM
  4. RibbonX XML: How can I put in a carriage return or new line within " " marks
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2010, 09:10 PM
  5. RibbonX - Is it possible to add help (F1) for a macro?
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-07-2010, 03:34 AM

Tags for this Thread

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