P
PCLIVE
While running code from ThisWorkbook, specifically "Workbook_Open", every
single line that is executed causes the Excel screen to refresh (very
slowly). Though it is slow, there is no reason for this to happen in the
first place. I've tried each and all of the following to try and prevent
this from happening..
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
It seems that just minimizing the excel window and then restoring it has a
long refresh time...but it only seems to happen on this particular file.
The file size is only 3602KB and I have other larger files that do not have
an issue.
Any ideas.
Paul
--
single line that is executed causes the Excel screen to refresh (very
slowly). Though it is slow, there is no reason for this to happen in the
first place. I've tried each and all of the following to try and prevent
this from happening..
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
It seems that just minimizing the excel window and then restoring it has a
long refresh time...but it only seems to happen on this particular file.
The file size is only 3602KB and I have other larger files that do not have
an issue.
Any ideas.
Paul
--