Consulting

Results 1 to 3 of 3

Thread: Change appearance of custom buttons on Excel ribbon based on cell status or contents?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Oct 2021
    Posts
    12
    Location

    Change appearance of custom buttons on Excel ribbon based on cell status or contents?

    I've got some buttons in an add-in on a custom ribbon (with custom icons).

    Is it possible to change the appearance of such a button based on the contents or state of a cell in a workbook ? (either through the customUI XML or through VBA)

    Example from the built-in buttons of Excel that I would like to mimic : When selecting a cell that is "bottom aligned", on the Home -> Alignment button group, the button for "bottom alignment" is highlighted. When selecting a cell that is "top aligned", on the same button group the button for "top alignment" is highlighted.

    See screenshots in attachments for what I would like to achieve with my own buttons.
    Attached Images Attached Images

Tags for this Thread

Posting Permissions

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