dss28
Board Regular
- Joined
- Sep 3, 2020
- Messages
- 165
- Office Version
- 2007
- Platform
- Windows
Hi,
I read in several post on internet about speeding up the macro based excel programs.
I adopted the following procedure and as recommended added these lines in every macro.
however still i feel the speed is very less although it depends upon several factors besides correct coding to which i am very new.
can someone guide if this is the right approach.
the lines i added in every macro are:
Sub ()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
Code....
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
End Sub
I read in several post on internet about speeding up the macro based excel programs.
I adopted the following procedure and as recommended added these lines in every macro.
however still i feel the speed is very less although it depends upon several factors besides correct coding to which i am very new.
can someone guide if this is the right approach.
the lines i added in every macro are:
Sub ()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
Code....
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
End Sub