Problem with Application.Calculation

[[email protected]]

Not sure whats going on, been running a few test over my code, and out of the blue (after a few crashes).

The Excel Macro doesnt work now. I am getting Run-time Error 1004, Method 'Calculation' of Object'-Application Failed.

this happens right away under Private Sub Workbook_Open();

and it seems that it errs for:

Application.Calculation = xlCalculationManual

or

Application.Calculation = xlCalculationAutomatic


Not sure what to do. I am under Excel 2013. and the Excel is an xlsm type.

[Solus Rankin]

It would be easier to trouble shoot if you could redact any sensitive information and post your workbook as an example.

To post a workbook, click 'Go Advanced' below and use the paperclip in the toolbar to navigate to your document.

[JosephP]

I reckon it's a timing issue-you can't change calculation state unless there's an open workbook. put the code into a routine in a normal module and call it with application.ontime

Please Login or Register  to view this content.

[[email protected]]

This is giving me headaches.... it errs on "Application.Calculation = xlCalculationManual", on Sub Workbook_Open.

Private Sub Workbook_Open()


ThisWorkbook.Activate

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Visible = False
.
.
.
.
End Sub
[/CODE]