dlh
12-01-2009, 04:20 PM
I have a problem that is similar to ScreenUpdating, but is probably unrelated.
At the end of running my VBA code (with ScreenUpdating = False) the Excel window is cluttered with ghosts of sections of other sheets in my document. Sometimes it's only an control button from another sheet that is redrawn on top of the active sheet. Sometimes it's overlapping sections of every non-hidden sheet in the document, even if my VBA code doesn't have anything to do with the other sheets. When I manually force a screen refresh by clicking the tab of a different sheet and then back, the screen is redrawn correctly.
This problem is occuring only in Excel 2007. The same document's VBA code running under Excel 2003 on a different machine does not have this problem.
I know ScreenUpdating is not the problem, because when I disable the line ScreenUpdating = False, the code does take longer to run, the screen flickers, and the redraw ghosting problem doesn't occur.
Does anyone recognize this behavior? Any advice for diagnosing the cause?
At the end of running my VBA code (with ScreenUpdating = False) the Excel window is cluttered with ghosts of sections of other sheets in my document. Sometimes it's only an control button from another sheet that is redrawn on top of the active sheet. Sometimes it's overlapping sections of every non-hidden sheet in the document, even if my VBA code doesn't have anything to do with the other sheets. When I manually force a screen refresh by clicking the tab of a different sheet and then back, the screen is redrawn correctly.
This problem is occuring only in Excel 2007. The same document's VBA code running under Excel 2003 on a different machine does not have this problem.
I know ScreenUpdating is not the problem, because when I disable the line ScreenUpdating = False, the code does take longer to run, the screen flickers, and the redraw ghosting problem doesn't occur.
Does anyone recognize this behavior? Any advice for diagnosing the cause?