Excel 2007, Custom Right Click Menu Doesn't Work in Table

[Jeff]

I've developed some VBA code that deploys custom Right Click Menus (to
the Cell, Row, Column and Ply menus) in Excel 2007. While the code
works normally, it doesn't Work in a Table region. Can anyone suggest
what I need to do to make this code work in a Table?

Thanks for any insights.


Jeff

 

[Ron de Bruin]

Hi Jeff

The name of this toolbar is

Application.CommandBars("List Range Popup")

 

[Jeff]

Hi Ron,

Thanks for posting. I saw your post to that effect elsewhere but was
unsure how to determine whether or not the current selection was a
Table or not ... I can't rely on it always being "Table1" for
example ... I need this to work in any 2007 Table on any sheet. Can
you suggest code I can use to make that determination?

Thanks!

Jeff

 

[Ron de Bruin]

If you add a option in this popup menu you will see it when you right click in every table in your workbooks.
If you want that the option is also in the normal Cell menu you must add it to both popup menus

If you need help post back

 

[Jeff]

Thanks for your help, Ron - I got it worked out now.

Jeff