Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="UserForm" label="Userform" >
<group id="customGroup" label="Custom Group" visible="false" >
<button id="Btn1" label="UserForm" image="UserForm" onAction="ShowForm"/>
<button id="Btn2" label="Hide User Form" image="Hide" onAction="HideForm"/>
</group>
I then right clicked on this button to show on the QAT.
in a module i have this
Code:
Sub ShowForm(control As IRibbonControl)
iUserForm1.Show vbModeless
End Sub
Sub HideForm(control As IRibbonControl)
iUserForm1.Hide
end sub
dan