Thread: kb973593 bug
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
 
Posts: 179
Default kb973593 bug

Yes, this is a bug and has been reported to Microsoft. Hopefully, MS will fix
these problems asp.

But here is the simple soltuion till MS fix....

Sub Sample_Report_Refresh()
'Set screen update false
Application.ScreenUpdating = False

'Here will come code
'........
'........
'........



'Reset Screen
Application.ScreenUpdating = True
Call Reset_Screen
End Sub
Function Reset_Screen()
With ActiveWindow
.ScrollColumn = 1
.ScrollRow = 1
.Zoom = .Zoom - 1
.Zoom = .Zoom + 1
End With
End Function

Best regards,
Muhammed Rafeek


"Lance Phillips" wrote:

Does any one know if Microsoft is aware of the kb973593 bug and if
they are fixing it?
.