View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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