[nehanaik25]

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.

[nehanaik25]

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]

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 .