Problem with Workbook Events and reading Table Objects

Question

Hi,

I am working on an excel workbook add-in where I'm supposed to add a menu item to the ribbon which I already done. I have to enable this menu item when the user clicks on the table object in the worksheet.

Can anyone please tell me what event should I use to achieve this and how to find out of the current cell is part if a table object or not.

Thanks,

Kavita

Answer 1

I just used the worksheet.activecell.listobject and checked if the listobject is not null that means the current cell is a part of a table