Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007, Custom Right Click Menu Doesn't Work in Table
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007, Custom Right Click Menu Doesn't Work in Table
Hi Jeff
The name of this toolbar is Application.CommandBars("List Range Popup") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jeff" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007, Custom Right Click Menu Doesn't Work in Table
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007, Custom Right Click Menu Doesn't Work in Table
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jeff" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007, Custom Right Click Menu Doesn't Work in Table
Thanks for your help, Ron - I got it worked out now.
Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost right-click menu in Excel 2007 | Setting up and Configuration of Excel | |||
Excel 2007, Custom Right Click Menu Doesn't Work in Table, Help! | Excel Programming | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Cannot click twice on custom menu in Excel | Excel Programming | |||
custom right click menu | Excel Programming |