cagataybaser
09-05-2014, 06:03 AM
Hello everyone I am very new in website and Office 2007 Ribbon UI
I add two checkBoxes in the ribbon using xml (with Custom UI Editor for Microsoft Office) ,They execute vba code called KOLONAC and it works fine.What I need that is to check/uncheck all checkBoxes with another sub. My xml codes :
<checkBox id ="F20" label="F2" tag="F20" getPressed="GetPressed" onAction="KOLONAC" />
<checkBox id ="F21" label="F21" tag="F21" getPressed="GetPressed" onAction="KOLONAC" />
And I need to put some extra code inside of this sub to uncheck all checkboxes
Sub Button29_Click(control As IRibbonControl)
Sheets("Main Sheet").Columns("B:ZZ").Hidden = True
'some code too add here to uncheck all checkboxes
End Sub
I will be really really happy if you help me.
I add two checkBoxes in the ribbon using xml (with Custom UI Editor for Microsoft Office) ,They execute vba code called KOLONAC and it works fine.What I need that is to check/uncheck all checkBoxes with another sub. My xml codes :
<checkBox id ="F20" label="F2" tag="F20" getPressed="GetPressed" onAction="KOLONAC" />
<checkBox id ="F21" label="F21" tag="F21" getPressed="GetPressed" onAction="KOLONAC" />
And I need to put some extra code inside of this sub to uncheck all checkboxes
Sub Button29_Click(control As IRibbonControl)
Sheets("Main Sheet").Columns("B:ZZ").Hidden = True
'some code too add here to uncheck all checkboxes
End Sub
I will be really really happy if you help me.