Excel 2003 Calculate Event

[Peter Haserodt]

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

 

[Tom Ogilvy]

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.

 

[Peter Haserodt]

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