Worksheet with macro ensnared ghost image

aodhan

New Member
Joined
Nov 12, 2009
Messages
7
Hi,

Let me see if I can describe this correctly. I have a series of worksheets that utilize macros to unprotect sheets, utilize lookup and pivot tables, refresh, clean data from columns, and then reprotect sheet. Everything with the macros is working fine. My data is doing what I want it to accomplish.

However, when I click on the tab to go to another worksheet in the same workbook, I am seeing a "ghosted" residual image of the previous worksheet. It might be 3in by 4in or 2in by 6in across the screen. If I click another tab and come back, the screen image is fine.

This is part of an automated workbook. The "ghost image" will mess up the users. I can add a line direction to "click another tab and then return to this tab" but the ghost image will block this direction over half the time.

I am looking for a macro worksheet/tab/screen refresh command or way to "git rid" of the ghosted/residual image. Thank you.:rolleyes:

Help :confused:,

A
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

aodhan

New Member
Joined
Nov 12, 2009
Messages
7
Re: Worksheet with macro ensnared ghost image/FOUND IT

I found my own answer in a Past Tip of the Day:pray:. Here it is if anyone needs to clear up a "ghosty" screen.:oops: Thanx, Mr Excel & BJelen.

Past Tip of the Day
My tip of the day is from a bit of my own experience. As you are learning to write code, you've probably learned that you can radically speed up your macro by turning off the screen updating while the macro runs. You would add this line of code to your macro:

Sub Test()
Application.ScreenUpdating = False
...macro code here [Just place what you need in here.]
Application.ScreenUpdating = True​
End Sub

So, the tip of the day, whether you are writing macros in Excel 97, Excel 2000, or Excel 2002, always turn the screen updating back to true with Application.ScreenUpdating = True​
By Bill Jelen on 13-Jul-2002
 

Watch MrExcel Video

Forum statistics

Threads
1,118,047
Messages
5,569,864
Members
412,298
Latest member
dietitiann
Top