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 :).
 
Back
Top