Scrambled Screens - Refresh problem

nevermind

"nevermind" - as in found a solution?
I face the same problem when I run a web query (through VBA) and 2 workbooks are open. It is however temporary and last only for the duration of the query.

well, i noted, after posting a reply, that the original wquestion was from 2005... I had posted a 'screen refresh' problem a few days ago... you might want to look at it if this is your problem... I'd be interested in knowing if this is more widespread

Actually 2005 is when I joined the forum -- my question was new.

But after receiving an underwhelming response here I did some more research and have come to the conclusion that it's a Microsoft bug caused by one of their most recent security patches.

I'll give them a few weeks to fix it before spending more of my time digging for a cure.

Well found that it was MS09-067: Description of the security update for Excel 2007: November 10, 2009 --> http://support.microsoft.com/kb/973593

In the article they supply workarounds (yet to implement) but no mention of a fix, nice.

Thanks for posting that!

I figured Microsoft would fix things pretty quickly seeing how many power users were highly annoyed. But I'm surprised and disappointed to see they haven't...

OK a bit more on this, I found 2 fixes/workarounds until MS can get this resolved...

Uninstall the Security patch -----------------

This was the best option due to the persons using my speadsheet did not like all of the screen refreshing, was annoying to say the least ---

1 – Close Excel
2 - Control Panel --> Add or Remove Programs, click “Show updates” at the top, then scroll down to the MS Office section, then click ‘Security Update for Microsoft Office Excel 2007 (KB973593), then click remove.

3 - Then if you want you can install the previous security patch for Excel --> This security update KB973593 replaces the following security update:
969682 (http://support.microsoft.com/kb/969682/ ) MS09-021:



Code Workaround -------------------------------

Add this code to Worksheet_Activate or Worksheet_change, etc..., I used this due to in my speadsheet the names of the sheets are not static names


'-----------MS Bug MS09-067-KB973593 workaround----------
SheetName = ActiveSheet.Name
Sheets(SheetName).Select
'--------------------------------------------------------

http://support.microsoft.com/kb/978522/ the hotfix Microsoft released to fix the issue , I installed and is working fine.

Another solution I found was to use the worksheet change event and enter the following code
Application.ScreenUpdating=True