dss28
Board Regular
- Joined
- Sep 3, 2020
- Messages
- 165
- Office Version
- 2007
- Platform
- Windows
i have a program which has few sheets very hidden,
my program is running very slow and hence i am using following code at the start of the Sub or Private Sub
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
and following code at the end of the code
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
even then my program is very slow and the screen flickers or if clicked anywhere on the form during this, the form goes blank / white and after 10-20 seconds, the code is executed.
my questions are:
1. since the sheets are very hidden on to which the data is getting stored, is it hindering the process and delaying the code execution?
2. Is any of the false and true application events as above hindering the speed of the code?
3. Am i required to add / delete any of the above application true / false codes??
please help
my program is running very slow and hence i am using following code at the start of the Sub or Private Sub
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
and following code at the end of the code
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
even then my program is very slow and the screen flickers or if clicked anywhere on the form during this, the form goes blank / white and after 10-20 seconds, the code is executed.
my questions are:
1. since the sheets are very hidden on to which the data is getting stored, is it hindering the process and delaying the code execution?
2. Is any of the false and true application events as above hindering the speed of the code?
3. Am i required to add / delete any of the above application true / false codes??
please help