View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Excel 2003 (8316.8221) screen corruption

Sounds like you have been impacted by the recent KB973475 patch for Excel
2003 of 09-Nov-2009.

Try disabling ScreenUpdating at the start of your code and reset when done
Application.ScreenUpdating = False ' True

Could you report back if this has helped or not.

MS are aware problems with this patch and also KB973593 for Excel 2007.
Hopefully it won't be too long before the update is updated.

Regards,
Peter T


"CSSLevel2" wrote in message
...
Hi

Excel 2003 (11.8316.8221) SP3 on Windows XP

When the Excel starts it activates the first sheet in the workbook but
shows
portions of the second and third sheet "bleeding" into the first sheet.
This
is easily worked around by say minimising and maximising the workbook or
causing it to repaint in some other way. After the repaint the first
sheet
shows correctly in full.

a) Has an update to Excel been issued which fixes this problem?
b) Can you think of a good workaround (given the details below)?

The workbook is a VBA application which has worked well for a number of
years. It has broken as described above since an update to Excel in
mid-October. The broken build is 11.8316.8221 SP3.

In the workbook open event a number of sheets are unprotected and then
protected (for drawing objects and scenarios). If this functionality is
commented out then the problem goes away. This behaviour looks shoddy and
is
difficult to explain to the application's customers.

Thanks for your help.