| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: top of screen "File Name [Group]", how to remove [Grou | Excel Discussion (Misc queries) | |||
| Control not added to "Object/Plot" command bar in Excel 2007 | Excel Programming | |||
| Excel 2003: Control tab in "Format Control" doesn't show up. | Excel Programming | |||
| Excel 2003: Control tab in "Format Control" doesn't show up. | Excel Programming | |||
| How to control "Date Time Picker ActiveX Control" | Excel Programming | |||
Linear Mode
