Hello,
I've got a VBA macro that does the following:
Application.Calculation = xlCalculationManual
If (Application.Calculation <> xlCalculationManual) Then
MsgBox("Doesn't work!")
End If
The macro is triggered on a Worksheet_Change() event. Most of the tim time
it works, but in some cases it does not work. Does anyone know of any
situations when this property becomes read-only?
Thanks!
Bookmarks