ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2007 Customui - is it possible to control the visbility of a "grou (https://www.excelbanter.com/excel-programming/441814-2007-customui-possible-control-visbility-grou.html)

Dreiding

2007 Customui - is it possible to control the visbility of a "grou
 
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

Ron de Bruin

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


Dreiding

2007 Customui - is it possible to control the visbility of a "
 
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" 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

.



All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com