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 |
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 |
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