ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rows right click menu? (https://www.excelbanter.com/excel-programming/445505-rows-right-click-menu.html)

Charlotte E.[_3_]

Rows right click menu?
 
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


Claus Busch

Rows right click menu?
 
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

Charlotte E.[_3_]

Rows right click menu?
 
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



All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com