Simplifying Ribbon Modification at Runtime

Access MVP Albert Kallal has developed a Ribbon class object that you can use to simplify modifying Ribbon commands at runtime.

The office ribbon is an amazing new interface.

The problem with the ribbon is that takes a lot of code to change the ribbon at runtime.

Solution: With my ribbon class you can enable, hide, change label text, or pictures of a button with great ease and very little code.

This ribbon class allows you to use the simple "old style" syntax to enable, hide, or change the text of a button.

e.g.:

meRib("Button1").enabled = true

meRib("Button1").label = "this is the new text" & _

                      " for button1 on the ribbon"

meRib("Button1").picture = "HappyFace.png"

The entire article, along with a sample implementation of the class, is available here.

Office Blogs Comments

Comments: (1) Collapse

  • Excellent stuff, Albert. Thank you for making this available.

Comments

Comments: (loading) Collapse