Prev: How to set macro to run every 15 minutes?
Next: data splitting
From: Dreiding on 19 Apr 2010 21:22
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
From: Ron de Bruin on 20 Apr 2010 00:12
See

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


--

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



"Dreiding" <Dreiding(a)discussions.microsoft.com> wrote in message news:1E297B5F-167A-44F0-9EF2-415E355188AB(a)microsoft.com...
> 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
 | 
Pages: 1
Prev: How to set macro to run every 15 minutes?
Next: data splitting