Office 2013 Slow VBA 1

[ClulessChris]

Why is vba so slow to run in office 2013 when compared to earlier versions of office?

I find everything much slower but more noticeable are routines in Excel. I've tried running the following first but get limited results in terms of speed.

Function StopOperations()
    With Application
        .PrintCommunication = False: .Calculation = xlCalculationManual: .EnableEvents = False
    End With
    ActiveSheet.DisplayPageBreaks = False
End Function

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[PHV]

You forgot this:
Application.ScreenUpdating = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[combo]

In my case, in earlier excel version, the same macro occasionally is very, very slow. It happens when I have other workbook with macros opened. The other workbook has only some API warpers, no event procedures.

combo