Application.Calculation = xlCalculationManual fails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
After doing some additional digging, it looks like the property becomes
read-only when you are pasting values into a worksheet (which triggers the
event, which triggers the macro). Why does this happen? Are there other
situations where this occurs?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get Control.State to work 15
Application.Calculation = xlCalculationManual not working 5
bug: Worksheet_Change clashes with dropdown list validation. 4
How do Excel define the application area? 3
Activating ManualCalc for any workbook opened 2
Problem with Hiding Every Other Column - Still need Help 3
Application.Calculation gives run time error 6
hide colum based on cell value on each worksheets 2

Back
Top