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

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:
Joined
Apr 19, 2012
Messages
6
Reaction score
0
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
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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

Top