Customization of Office Ribbon Items

Question

In excel i am able to manage the visibility of a Command Bar button say Sort and Filter, it works properly first time when the ribbon is loaded.

But what i want is let say in my excel sheet i have a list object and my cursor is inside list object, i want to disable the command bar button, but when it is out side i want to enable it.

How do i achieve this.

---

K K Sanghi

Answer 1

you have to call ribbon.InvalidateControl to ask runtime to re-evaluate your callbacks for that button.

Answer 2

ribbon.InvalidateControl  works when we have Custom Ribbon Button not for in built buttons.

---

K K Sanghi

Answer 3

i think it will also work if you repurpose built in buttons and provide callbacks. How do you manage it for first time when ribbon is loaded?

Answer 4

Thanks Damian,

Call back worked by using ribbon.InvalidateControl 

---

K K Sanghi