Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Calculation = xlCalculationManual mystery | Excel Programming | |||
How to set in XLA calculation on xlCalculationManual | Excel Programming | |||
Application.Calculation | Excel Programming | |||
Application.Calculation=xlCalculationManual causing run time error? | Excel Programming | |||
Application.Calculation exception | Excel Programming |