View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Auto insert/delete on other sheet

Frankly, I can't remember whether it does or not and I don't have a copy
handy to test with. I know it doesn't do it in xl97. I tested it in
xl2002, so I know it does there.

Easiest is to test it

in a new blank workbook, put this into sheet1.


Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Then delete a row. Then insert a row.

If you do get a message, it does, conversely if you don't get a message, it
doesn't. <g

--
Regards,
Tom Ogilvy

"broogle" wrote in message
oups.com...
Do you mean delete/insert in Excel 2000 will not trigger the change
event?