How can I fix the Excel ghost/phantom tab glitch?

Asked Nov 20 '19 at 15:05

Active Nov 20 '19 at 15:07

Viewed 71 times

I am working with a large Excel spreadsheet full of VBA macros, but I keep running into the infamous Excel glitch that shows a ghost image of one tab on top of the currently selected tab. Has anybody else seen this? Does anybody have any suggestions on how to fix this?

edited Nov 20 '19 at 15:07

BigBen

46,229
7
24
40

asked Nov 20 '19 at 15:05

Chris Ross

3

Do you use `.Select` or `.Activate` in your code? If so, don't. There are very very few reasons to do so. See: https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba – Scott Craner Nov 20 '19 at 15:08
I do use both. Do you think that is causing my problem? – Chris Ross Nov 20 '19 at 15:09
2

Yes I do think that is what is causing the problem. – Scott Craner Nov 20 '19 at 15:10
1

It is also slowing your code, and making it harder to read. – Scott Craner Nov 20 '19 at 15:11
Thanks Scott! I will take a look at this. – Chris Ross Nov 20 '19 at 15:20

How can I fix the Excel ghost/phantom tab glitch?

0 Answers0