Rows right click menu?

C

Charlotte E.

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
 
C

Claus Busch

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???
Click to expand...

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open my default template when right click, select New MS Word doc within a folder 0
Menu Macro Not Executing - Need Help 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Custom right-click menu without changing Excel.App 1
commandbar control works on some computers, not others 1
Add File menu to custom toolbar 4
Get line no from right click menu ("Cell") 5
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0

Top