Custom ribbon checkboxes do not retain values when file is closed.

Hi Eric,

I'd say you need to save the status of the check boxes somewhere and reset them to this saved value when you first open the workbook. I'd need an example file to examine how and where this should be done.

Here is an example file. Look on the Inputs and Ratios Tab on the ribbon. The checkboxes show/hide sheets. If have Sheet 1 and Sheet 3 are visible when the file is opened, how do I make Checkbox 1 and Checkbox 3 be checked?

Hi eric,

I can't seem to find a way to make those boxes checked or not. It looks like the Ibuttoncontrol is a Office Object and is read only. I can read the Tag and Id of the control but it doesn't look like it is checkable using Excel VBA code. A mouse click seems to be the only way I can get them to change.

On http://msdn.microsoft.com/en-us/libr...oncontrol.aspx it claims it is not supported using VBA. I think that is the final answer.

I wonder if other programmers have an answer.