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?
|