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

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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
 
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
 
Back
Top