Thread: kb973593 bug
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
XL Software Solutions XL Software Solutions is offline
external usenet poster
 
Posts: 1
Default kb973593 bug

On Dec 3, 4:57*pm, Lance Phillips wrote:
On Nov 24, 10:46*am, MrXCell wrote:

On Nov 23, 5:36*pm, Lance Phillips wrote:


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


Exactly what problem are you referring to? Microsoft is working on a
fix to the worksheet display corruption problem induced by KB973593 on
Excel 2007. KB973475 has done the same to Excel 2003. Have you been
experiencing other problems following the installation of KB973593? If
so, please post details here.


In some cases userforms will disappear from view. When you click the
screen it will reappear. This does not happen if the security update
is removed.



I've had to rewrite a lot of code for my product because of this issue
- some workarounds I found (Excel 2007):

In VBA, program a zoom in / zoom out function. It seems that when you
zoom on a page it refreshes the worksheet and displays correctly.
Function ZoomFix()
ActiveWindow.Zoom = ActiveWindow.Zoom - 1
ActiveWindow.Zoom = ActiveWindow.Zoom + 1
End Function
If you have code that interacts with the Application.ActiveWorkbook
object you will see these issues, so call the zoom function mentioned
above at the end of your code.

I hope this helps

Regards

Dave