how to disable buttons on a custom ribbon

**diego208** · 03-22-2020, 02:23 PM

Hi Guys,

I made a custom ribbon with "custom UI editor", and the ribbon has almost 30 buttons in 3 groups.

I want to disabled some of them if the user want it. In a excel sheet I have the button list and in the next column the user choose if he want enabled or disabled them one by one.
This process should be doing when the excel file is open, so, if the user want enabled a disabled button he can do it but he can see the changes only when he close and open the file again.

on xml for each button I put "getEnabled="ButtonGetEnabled" (the same for all) and "tag="button1" (different name on tag, deppending of the button name)

but I don't know if it is ok and how write the sentences on vba to work it.

I think is so hard or do I tangled to much with it?

thanks for your help

**Andy Pope** · 03-23-2020, 03:36 AM

You need to invalidate the ribbon object in order to get the buttons to update.
In this small example there is a button on the worksheet which will refresh the button state using the Invalidate method

ribbon x m l creates a new tab, group and 3 buttons