Screen Refresh (Ghost) Problem

[RakRoss]

Screen Refresh Problem

Hi,

New to the forum and have had the same problem as in this post:

http://www.mrexcel.com/forum/excel-questions/430562-screen-refresh-problem.html

The solutions here haven't solved the problem I have. I'm using the Excel 2013 and get the ghost image that disappears after scrolling or changing tab. This appears over the top of the current worksheet and only occurs after certain macros are run in the book.I can't seem to get it to go. It usually occurs when i run a macro that hides or un-hides a large amount of tabs.

Currently I just use .visible = false for all tabs to hide.

Would be great to get this sorted so any help is appreciated!

Thanks in advance

RR​

 

[Fishboy]

Hi RR,

Do your macros open with Application.ScreenUpdating = False ?

 

[RakRoss]

I have had them start with Application.ScreenUpdating = False and end in Application.ScreenUpdating = True. Ive also run them with out either and the problem presists :s

 

[Sah213]

I was having a massive problem with this "ghosting" issue of segments of a previous screen displaying over the top of the current one after running VBA, the code found here - Redraw screen? - Excel General - OzGrid Free Excel/VBA Help Forum , finally solved it for me (albeit added to the end of existing VBA, rather than specifically run at Workbook close);

[LIST=1]
[*]Sub Workbook_BeforeClose(Cancel As Boolean)
[*]Dim wSheet As Worksheet
[*]On Error Resume Next
[*]Application.ScreenUpdating = False
[*]For Each wSheet In Worksheets
[*]wSheet.Select
[*]Range("A1").Select
[*]Next
[*]Application.ScreenUpdating = True
[*]End Sub
[/LIST]