TRIGERRING A CALCULATION

F

FARAZ QURESHI

MVP Biff informed me a while ago that inserting a sheet does not trigger a
calculation while deleting a sheet does so. Could there be anyway/code to
trigger such a calculation upon the event of inserting a new sheet like "New
Sheet Eevent"?

Kindly provide a code.

Once again,

Thanx Biff!
 
M

Mike H

Hi,

There's a workbook event. Open vb editor, double click this workbook and
paste this in

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Application.Calculate
End Sub

Mike
 
Top