Hi,


I want to add a menu-item to the "Rows Right Click Menu".

You know, the context menu, which appears if you right-click on any of
the row numbers to the very left of a spreadsheet.

But, what's the name of the menu to use???

Like, adding to the tabs:
Application.CommandBars("Ply").Controls.Add

Or, adding to the cells:
Application.CommandBars("Cell").Controls.Add

How to do it to the "Rows Right Click Menu"?

Oh, and now we're at it: The "Columns Right Click Menu"?
(Don't need it right now, but perhaps in the future :-)

(Is there a list of all those commandbars somewhere???)


Thanks


CE

Hi CE,

Am Fri, 16 Mar 2012 08:35:20 +0100 schrieb Charlotte E.:

You know, the context menu, which appears if you right-click on any of
the row numbers to the very left of a spreadsheet.

But, what's the name of the menu to use???

Application.CommandBars("Row")
and for right-click on column header
Application.CommandBars("Column")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks :-)

CE


Den 16.03.2012 10:15, Claus Busch skrev:
Hi CE,

Am Fri, 16 Mar 2012 08:35:20 +0100 schrieb Charlotte E.:

You know, the context menu, which appears if you right-click on any of
the row numbers to the very left of a spreadsheet.

But, what's the name of the menu to use???

Application.CommandBars("Row")
and for right-click on column header
Application.CommandBars("Column")


Regards
Claus Busch