Ribbon command idMso for Excel "Insert Cells"

[John Huschka]

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?

 

[Patrick Schmid [MVP]]

Hi John,

When the button changed into Insert Cells, right-click it and add it to
your QAT. Then open the QAT Customization Dialog and hover over the
command you just added on the right. It should show the idMso in the
parenthesis of the tooltip.


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[John Huschka]

This was an awesome suggestion--best technique that I've found for finding
IdMso.

Unfortunately, the ribbon callback is just not happening. The IdMso, as
placed into the QAT is "CellsInsertDialog"--which is what I receive a ribbon
callback for when the caption is "Insert Cells...". But, when I select an
entire row/column and the caption is "Insert Cells", I do not receive the
callback.

Interestingly, I don't get the callback either when I select an entire
row/column and click on the button in the QAT.

Any ideas?

I appreciate your willingness to help with this. It is a pretty critical
problem to what I'm doing.
--
John Huschka

Hi John,

When the button changed into Insert Cells, right-click it and add it to
your QAT. Then open the QAT Customization Dialog and hover over the
command you just added on the right. It should show the idMso in the
parenthesis of the tooltip.


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

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?

 

[Patrick Schmid [MVP]]

This was an awesome suggestion--best technique that I've found for
finding

IdMso.

Second-best The best technique is the search box my RibbonCustomizer
add-in has Especially after I fixed the search bug (fix is
incorporated in the beta).

Unfortunately, the ribbon callback is just not happening. The IdMso, as
placed into the QAT is "CellsInsertDialog"--which is what I receive a ribbon
callback for when the caption is "Insert Cells...". But, when I select an
entire row/column and the caption is "Insert Cells", I do not receive the
callback.

Looking at this, I would say that CellsInsertDialog changes into
CellsInsertSmart. But you said you have overridden both already?


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Interestingly, I don't get the callback either when I select an entire
row/column and click on the button in the QAT.

Any ideas?

I appreciate your willingness to help with this. It is a pretty critical
problem to what I'm doing.
--
John Huschka

Hi John,

When the button changed into Insert Cells, right-click it and add it to
your QAT. Then open the QAT Customization Dialog and hover over the
command you just added on the right. It should show the idMso in the
parenthesis of the tooltip.


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

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]

Thanks for the response.

I just downloaded the customizer yesterday. I will take a bit more
extensive look at it (although the majority of my customization work is
done...just trying to "tune").

I have overridden both CellsInsertDialog and CellsInsertSmart.
--
Thanks,
John Huschka

This was an awesome suggestion--best technique that I've found for finding
IdMso.

Second-best The best technique is the search box my RibbonCustomizer
add-in has Especially after I fixed the search bug (fix is
incorporated in the beta).

Unfortunately, the ribbon callback is just not happening. The IdMso, as
placed into the QAT is "CellsInsertDialog"--which is what I receive a ribbon
callback for when the caption is "Insert Cells...". But, when I select an
entire row/column and the caption is "Insert Cells", I do not receive the
callback.

Looking at this, I would say that CellsInsertDialog changes into
CellsInsertSmart. But you said you have overridden both already?


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Interestingly, I don't get the callback either when I select an entire
row/column and click on the button in the QAT.

Any ideas?

I appreciate your willingness to help with this. It is a pretty critical
problem to what I'm doing.
--
John Huschka

Hi John,

When the button changed into Insert Cells, right-click it and add it to
your QAT. Then open the QAT Customization Dialog and hover over the
command you just added on the right. It should show the idMso in the
parenthesis of the tooltip.


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed




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?

 

[Patrick Schmid [MVP]]

Strange, from looking at this, it seems that Dialog changes into
Smart...so it should catch that callback...

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Thanks for the response.

I just downloaded the customizer yesterday. I will take a bit more
extensive look at it (although the majority of my customization work is
done...just trying to "tune").

I have overridden both CellsInsertDialog and CellsInsertSmart.
--
Thanks,
John Huschka

This was an awesome suggestion--best technique that I've found for finding
IdMso.

Second-best The best technique is the search box my RibbonCustomizer
add-in has Especially after I fixed the search bug (fix is
incorporated in the beta).

Unfortunately, the ribbon callback is just not happening. The IdMso, as
placed into the QAT is "CellsInsertDialog"--which is what I receive a ribbon
callback for when the caption is "Insert Cells...". But, when I select an
entire row/column and the caption is "Insert Cells", I do not receive the
callback.

Looking at this, I would say that CellsInsertDialog changes into
CellsInsertSmart. But you said you have overridden both already?


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Interestingly, I don't get the callback either when I select an entire
row/column and click on the button in the QAT.

Any ideas?

I appreciate your willingness to help with this. It is a pretty critical
problem to what I'm doing.
--
John Huschka


:

Hi John,

When the button changed into Insert Cells, right-click it and add it to
your QAT. Then open the QAT Customization Dialog and hover over the
command you just added on the right. It should show the idMso in the
parenthesis of the tooltip.


Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://ribboncustomizer.com
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed




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?