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