Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing the excel 2007 context menus...
Can anyone tell me how to access the command buttons on the 'Row' context
menu in Excel 2007. Using Id 293 works for Excel 2003 and it also locates a Row/&Delete... menu item but this seems to not be the one that pops up when you right click on a highlighted row. I'm trying to hook into the click event for this menu item. Jimm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing the excel 2007 context menus...
Hi Jimm
This is working Ok in 2007 Application.CommandBars("Row").FindControl(ID:=293 ).Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jimm" wrote in message ... Can anyone tell me how to access the command buttons on the 'Row' context menu in Excel 2007. Using Id 293 works for Excel 2003 and it also locates a Row/&Delete... menu item but this seems to not be the one that pops up when you right click on a highlighted row. I'm trying to hook into the click event for this menu item. Jimm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing the excel 2007 context menus...
Correct - I'm able to find that control but it seems to not be the one I'm
looking for... If I use the following code - I get no event firing... Office.CommandBarButton btn = (CommandBarButton)App.CommandBars.FindControl(miss ing, 293, missing, missing); btn.Click += App_DeleteClick; I find the control - but the event never fires... "Ron de Bruin" wrote: Hi Jimm This is working Ok in 2007 Application.CommandBars("Row").FindControl(ID:=293 ).Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jimm" wrote in message ... Can anyone tell me how to access the command buttons on the 'Row' context menu in Excel 2007. Using Id 293 works for Excel 2003 and it also locates a Row/&Delete... menu item but this seems to not be the one that pops up when you right click on a highlighted row. I'm trying to hook into the click event for this menu item. Jimm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Adding commands to the Excel 2007 Chart context menu | Charts and Charting in Excel | |||
[Excel '03] check-box menu items and cell context menus don't disp | Excel Programming | |||
Adding context menu to shapes in Excel 2007 | Excel Programming | |||
Excel 2007 menus - XML Notepad 2007 | Excel Programming |