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

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

Hi Tom,
TX
I thought something like sumtotal could be the reason but i did not know
why.
Some changes are not to the best :-(

Regards Peter


"Tom Ogilvy" schrieb im Newsbeitrag
...

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