Word Ribbon UI Help

[Sam1085]

Hi,

I've a Word ribbon toolbar with few callback buttons. Is it possible to highlight the ribbon callback button when running a macro?

Thank you!

[HansV]

See if this reply helps.

[Sam1085]

Hi Hans,

Thank you for the resource. I refer that.. But I didn't understand properly.

Simply I have to view button highlight while running the respective macro. (See below snap shot for more...)

img.png

Thanks!

[Rudi]

All ribbon versions of Office requires the use of XML to create, modify and delete ribbon buttons. Modifying the ribbon can not be done using VBA.

You will need to use either the add-in that is mentioned in the post that Hans linked to (Ribbon Editor) or you can use Custom UI Editor for Microsoft Office.

These tools expose the XML that controls the ribbons and you will need to find the necessary coding to change the colour of the button in XML and edit it into the code using the above tools. (Sorry...this is outside my knowledge).

[Sam1085]

Thank you Rudi for your response.

Yes, I've create my ribbon toolbar by using Andypope ribbon editor in past. And now I'm using custom UI editor for that.

My ribbon, callback buttons are works fine. Only I need to know how to highlight the respective button while running the vba macro code. (If it's possible)

Thanks!

[stuck]

As Rudi said, you can't tweak the Ribbon using VBA thus I doubt you can make the button on the ribbon change while code is running.

Instead, why not display messages in the Status Bar while the code runs? Something like this should work:

Code: Select all

    'inform user of progress
    With Application
        .Wait Now + TimeValue("00:00:01")
        .StatusBar = "hello world"
    End With

Ken

[Jay Freedman]

Sam, take a look at the pages http://gregmaxey.com/word_tip_pages/rib ... rt_IV.html and http://gregmaxey.com/word_tip_pages/rib ... art_V.html, and download the demonstration files there. I haven't done this myself, but it should work to let you display one image when the button has not been pressed and a different image when it has been clicked. I'm not sure how you would return to the first image when the macro ends.