They changed the functionality of the subtotal function so it respects all
hidden rows besides rows hidden by a filter, so I suspect this is why they
have altered the behavior.

--
Regards,
Tom Ogilvy



"Peter Haserodt" wrote in message
...
Hi,
(excuse my english)

does somebody know why Excel 2003 fires the calculate event, when rows /
columns will be hidden?

Example:

Range d5:= A1

Private Sub Worksheet_Calculate()
MsgBox "Hi"
End Sub

Hide now Row 1 and the event fires.
(It fires for the whole workbook)

In former Excel.Applications this did not happen?

Any idea?

Tx
Peter