Phantom Image

[kab7030]

Hi All,

I have been facing a strange problem. I have a big workbook with alot of code. It all worked fine until recently something strange started to happen.

Just to explain it better, assume i have a
workbook with three sheets. One is intial sheet, sheet2 and sheet3. The initial sheet has 1 button that takes user to sheet2 and does some initializations and clears the cells in sheet3.

sheet2 also has 1 button that does some calculations and jumps to sheet 3 (where sheet3 has about 6 to 7 buttons).

It all worked fine however recently when the button is clicked on the initial sheet, it does work as expected but also displays the phantom image of 6 to 7 buttons on sheet 2 (whereas these buttons actually exist on sheet 3). These are not actual buttons but only image of buttons.

Similarly if i press the button on sheet2, it takes me to sheet3 but again seems to generate several phantom images of same set of buttons on sheet3. So in sheet3 i can see the actual 6 to 7 buttons that i can click overlaid by phantom images of same buttons. However if i go back to sheet2 and come back to sheet3 by using sheet tabs the phantom images dissapers. This indicates that it is screenupdating problem.

In all my subs, i have included Application.screenupdating=false in the beginning and Application.screenupdating=true at the end.

I think it has something to do with Application.screenupdating and i have tried few things but nothing seems to change.

Anybody has any idea.

Thanks

 

[RoryA]

Do you have the MS update KB973593 update applied to your system? (You can view it in Control Panel under Add/Remove programs if you have the Show Updates option checked.)
If so, it can cause a 'bleed through' from one page to the next under certain circumstances. MS are aware of the issue.

 

[kab7030]

Thanks for reply.

The only update for excel i can see is KB 973475. The update you mentioned doesnt exists on my machine. Could this be an issue.

 

[RoryA]

I take it you are using Excel 2003 then? There is a similar issue with that one I believe (the one I mentioned is for 2007). See this conversation in the newsgroups.

 

[kab7030]

Excellent! Thanks that did the trick. I removed the update (IT department wont be happy) and it all worked as expected.

Thanks again. You have saved me alot of time.