Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and
menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Strange one John
Will test more this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Thanks for your help. It is very much appreciated!
-- John Huschka "Ron de Bruin" wrote: Strange one John Will test more this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Hi John
Can't find anything on this moment You can disable the whole menu maybe <command idMso="InsertCellstMenu" enabled = "false" / -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Thanks for your help. It is very much appreciated! -- John Huschka "Ron de Bruin" wrote: Strange one John Will test more this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Do you get the same results that I do? That is, are you unable to customize
"Insert Cells"? -- Thanks! John Huschka "Ron de Bruin" wrote: Hi John Can't find anything on this moment You can disable the whole menu maybe <command idMso="InsertCellstMenu" enabled = "false" / -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Thanks for your help. It is very much appreciated! -- John Huschka "Ron de Bruin" wrote: Strange one John Will test more this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Do you get the same results that I do?
Yes, I will see if I can get more information about this John I post back if I know more -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Do you get the same results that I do? That is, are you unable to customize "Insert Cells"? -- Thanks! John Huschka "Ron de Bruin" wrote: Hi John Can't find anything on this moment You can disable the whole menu maybe <command idMso="InsertCellstMenu" enabled = "false" / -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Thanks for your help. It is very much appreciated! -- John Huschka "Ron de Bruin" wrote: Strange one John Will test more this evening -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Huschka" wrote in message ... Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? -- John Huschka |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
John Huschka wrote on 06/19/2007 14:11 ET :
Trying to customize Excel 2007's ribbon "Home" tab, "Insert" split button and menu. I have successfully overridden the "Insert" button on the split button (command idMso = "CellsInsertSmart"). I have successfully overridden the "Insert Cells..." button on the split button menu (command idMso = "CellsInsertDialog"). But, a problem arises when I select an entire row/column and use the split button menu. The "Insert Cells..." changes to "Insert Cells" and is no longer recognized by my ribbon customization. I assume that I do not have the correct idMso. I have looked at all published resources I can find (e.g., charts from MSFT), and I cannot find this. It is not "SheetColumnsInsert", "SheetRowsInsert", or "InsertCellstMenu" (at least they don't work for this menu option). Has anyone seen this? Have a solution? John Huschka Hi, Can you provide the code to override the insert button, i am also looking for the same for 1 project. Vikas |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ribbon command idMso for "Insert Cells"?
Perhaps some of Ron de Bruin's examples will be some help.
http://www.rondebruin.nl/ribbon.htm -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "insert copied cells"? used to be "alt i e" still work | Excel Worksheet Functions | |||
How do I set my "Insert" key as a paste command shortcut in Excel | Excel Discussion (Misc queries) | |||
Is it possible to insert a macro command in an "IF" function? | Excel Worksheet Functions | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Insert 19 cells "Shift to the right" if cell contains "-" | Excel Programming |