Excel display Fault
There have been reports of a bug in an update for 2003 November 10th
KB973475
And for 2007............KB973593
Uninstall the update(s) for now and see if that helps.
Gord Dibben MS Excel MVP
On Tue, 1 Dec 2009 12:38:08 +1100, "Gilbert Bani"
wrote:
Out of about 50 people using an excel program I wrote, three people exhibits
a problem after running a macro, where a worksheet shows parts of other
worksheets.
Moving a mouse over the areas clears the problem area.
I believe some update from Microsoft has created this fault as it has only
started to fault last week.
All 3 people are running excel 2003 professional
Turning auto calculate off fixes the fault, however turning auto calculate
back on, immediately produces error
I use the following commands trying to overcome problem with no positive
results
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
.... my macro
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Regards Gilbert Bani
Ballarat IT Manager
WIN Television VIC LTD
Walker Street (PO Box 464)
Ballarat,VIC,3350 Australia
Tel: 61 3 5320 1318 Fax: 61 3 333 1598
|