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

See

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


--

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



"Dreiding" <(E-Mail Removed)> wrote in message news:1E297B5F-167A-44F0-9EF2-(E-Mail Removed)...
> 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

Hi Ron,

Worked great! Thank you!
- Pat

"Ron de Bruin" wrote:

> See
>
> http://www.rondebruin.nl/hidevisible.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
>
> "Dreiding" <(E-Mail Removed)> wrote in message news:1E297B5F-167A-44F0-9EF2-(E-Mail Removed)...
> > 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
> .
>