View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AM AM is offline
external usenet poster
 
Posts: 41
Default Application.Calculation = xlCalculationManual fails

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!