Excel how to add right click options on table object of excel 2007

N

nehanaik25

Joined
Apr 19, 2012
Messages
6
Reaction score
0
Hi,

I have to add some right click options(context menu of table object) on table object of excel.
I can add right click command bar buttons in excel workbook event 'Workbook_SheetBeforeRightClick'. But when i click on a table object i dont see my custom right click options.

anyone knows how to do it?

Thanks in advance.
 
Last edited:
i got the solution..

Intead of cell level i used table tevel command bar button..
i.e. replace Application.CommandBars("Cell")
with Application.CommandBars("List Range Popup")

Thanks
 
Glad you got this working and thanks for reporting back with the solution - it's a big help to people searching for the same thing :).
 

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

Excel Providing user message when RED X clicked & properly closing application. 2
Word Adding a watermark to a table 1
Access Passing the value to a table 1
Create a yes no message on a command button on click 0
Excel MS Excel in Win 10 3
Can't disable RIGHT CLICK 1
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
right click menu 1

Back
Top