Displaying custom ribbon image using callback

**ByteMarks** · 04-25-2025, 06:08 AM

I have this ribbon callback to deterimine the image of a button. As shown it's using the inbuild mso images, which works.

Please Login or Register  to view this content.

However, instead of using an mso image I want to use a custom image called "MyImage" that I've added to the XML.
I've tested that MyImage works when hard-coded into the XML, but when trying to set returnedVal = "MyImage" no picture shows.

So in this example, if a = b then no image is shown when it should show the custom image.

Please Login or Register  to view this content.

**romperstomper** · 04-25-2025, 07:36 AM

As I recall, the only method Ron de Bruin ever had for this was extracting the images from an unzipped copy of the file and then loading them from disk. There didn't appear to be any way to simply refer to embedded ones directly.

**ByteMarks** · 04-25-2025, 07:37 AM

I did it using GDI+ and having the images in a separate folder, but disappointed that there doesn't seem a way for VBA to reference images within the construct of the file.

In a module:

Please Login or Register  to view this content.

Usage

Please Login or Register  to view this content.

Useful info here too

**Artik** · 04-26-2025, 09:00 PM

A simpler workaround to the problem (if that is acceptable) is to prepare two buttons with hard-assigned icons. In turn, the code sets the visibility of the corresponding button. E.g. XML:

PHP Code:


<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="RibbonOnLoad">

  <ribbon>

    <tabs>

      <tab id="customTab" label="My Tab">

        <group id="customGroup" label="My Group">

          <button 

            id="myDynamicButton_1"

            label="Click Me"

            image="MyImage"

            getVisible="GetButtonVisible"

            size="large"

            onAction="MyButtonAction" />

          <button 

            id="myDynamicButton_2"

            label="Click Me"

            imageMso="AnimationOnClick"

            getVisible="GetButtonVisible"

            size="large"

            onAction="MyButtonAction" />

        </group>

      </tab>

    </tabs>

  </ribbon>

</customUI>

Of course, the MyImage icon is stored in an XML file.

VBA:

Please Login or Register  to view this content.

Artik

**ByteMarks** · Yesterday, 05:19 AM

Thanks Artik, that's a good workaround.

Displaying custom ribbon image using callback

LinkBack

Thread Tools

Rate This Thread

Display

Displaying custom ribbon image using callback

Re: Displaying custom ribbon image using callback

Re: Displaying custom ribbon image using callback

Re: Displaying custom ribbon image using callback

Re: Displaying custom ribbon image using callback

Thread Information

Users Browsing this Thread

Similar Threads

'Invalid image error :481' when displaying 7 charts or more as image

Put VBA ribbon together with Custom UI Editor Ribbon

Assistance with Custom Tab and Groups on Excel Office Ribbon using Custom UI Editor.

[SOLVED] An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls

[SOLVED] Callback for Ribbon drop down

Displaying and Updating Image Dynamically (ActiveX Image Control?)

[SOLVED] Hyperlink to an image in other worksheet, displaying entire image.

Bookmarks

Bookmarks

Posting Permissions