2007 Customui - is it possible to control the visbility of a "grou

[Dreiding]

I'm looking to have a "group" displayed only when "Sheet1" is active.
Is this possible? My UI code is:
-------------------------------------------------------------------------------
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab idMso="TabHome">
<group id="RGroup" label="Risk" insertAfterMso="GroupClipboard"
getVisible="getVisibleCallback">
<button id="ClearAll"
label="Clear All"
onAction="MyMacro"
screentip="Removes Risk table data and deletes all the rows"
imageMso="TableRowsDeleteExcel"/>
<button id="AppendRow"
label="Append Row"
onAction="MyMacro"
screentip="Appends new row to Risk table"
imageMso="TableRowsInsertBelowExcel"/>
<button id="DeleteRow"
label="Delete Row"
onAction="MyMacro"
screentip="Deletes selected rows from Risk table - Except the first row!"
imageMso="TableRowsDeleteExcel"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

 

[Ron de Bruin]

See

http://www.rondebruin.nl/hidevisible.htm

 

[Dreiding]

Hi Ron,

Worked great! Thank you!
- Pat

See

http://www.rondebruin.nl/hidevisible.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




.