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

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

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