Excel 2003 Calculate Event

  • Thread starter Thread starter Peter Haserodt
  • Start date Start date
P

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
 
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.
 
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
 
Back
Top