View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Grzes Grzes is offline
external usenet poster
 
Posts: 2
Default Trap insert row or column in Excel in VBA

Hi Filibuster

It's cool !!! , thank you it's work, but i found one way in this
solution , where my macro isn't work - i don't know why (i think, i
must use other id, but which ? ) , I was tested with :
Set Mycontrol = Application.CommandBars("Worksheet Menu
Bar").FindControl(ID:=296, Recursive:=True)
Set Mycontrol2 =
Application.CommandBars("Cell").FindControl(ID:=31 81, Recursive:=True)
Set Mycontrol3 =
Application.CommandBars("Cell").FindControl(ID:=29 2, Recursive:=True)
and in my opinion Mycontrol2 must worked when I click right mouse
button (insert) on the number row in Excel, but this solution not work
for this - its work when i execute this on any cells in excel.
Do you know which id i must use for this ?

Thank you again