disable autocalculation only in one workbook/worksheet

[robertkrz]

Is it possible to disable by VBA autocalculation only in one workbook or worksheet ? For example while opening workbook.
ray:
Any tips are appreciated !

 

[gnaga]

You can try the followings

Private Sub Workbook_Open()
    Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Deactivate()
    Application.Calculation = xlCalculationAutomatic
End Sub

GNaga

 

[robertkrz]

Hi,

I came almost to this same conclusion in midtime except that you have also deactivation on change.
Very well. It works fine !

Thanks a lot !

BTW:
Do you have idea how to compare to dates? One inserted in a form and second one stored as text in a cell.

Thanks in advance.