Rows right click menu?

March 16th, 2012 - 02:35 am ET by Charlotte E. | Report spam
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
email Follow the discussionReplies 2 repliesReplies Make a reply

Replies

#1 Claus Busch
March 16th, 2012 - 04:15 am ET | Report spam
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

Similar topics