View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 2007 Customui - is it possible to control the visbility of a "grou

See

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


--

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



"Dreiding" wrote in message ...
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

---------------------------------------

---------------------------------------
Thanks
- Pat