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
|