TRIGERRING A CALCULATION
 

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!

--

Best Regards,
FARAZ A. QURESHI

TRIGERRING A CALCULATION
 

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

"FARAZ QURESHI" wrote:

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!

--

Best Regards,
FARAZ A. QURESHI