.XLSM Slow issues

Hi jaimie,

I have the same kind of problem with a macro that opens/does copy/paste operations/close different excel formats (ie xls, xlsx, and xlsm). When the macro comes to xlsm (with some code) files becomes very slow. I tried to boost the macro with the following code:

Public Sub BoostMacroPerformance(bln As Boolean, ToEvents As Boolean)
    If bln = True Then
        Application.ScreenUpdating = False
        Application.Calculation = xlCalculationManual 
        Application.DisplayAlerts = False 
        If ToEvents = True Then Application.EnableEvents = False 
    ElseIf bln = False Then
        Application.ScreenUpdating = True
        Application.Calculation = xlCalculationAutomatic
        Application.DisplayAlerts = True
        Application.EnableEvents = True
    End If

Also I open files in readonly mode with:

dim FilePath as string
Workbooks.Open FileName:=FilePath, ReadOnly:=True

but they don't reduce xlsm elaboration time. If you came with a solution please let me know!

Diego