Prev: C# Add-in and PivotTables
Next: putting a picture onto a userform without using the vba window.
From: Lance Phillips on 23 Nov 2009 17:36
Does any one know if Microsoft is aware of the kb973593 bug and if
they are fixing it?
From: MrXCell on 24 Nov 2009 11:46
On Nov 23, 5:36 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> 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.
From: Gord Dibben on 24 Nov 2009 11:53
This bug has been reported.

I am confident a bug-fix will be out in due time.


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 14:36:54 -0800 (PST), Lance Phillips
<lgp.owl.soft(a)gmail.com> wrote:

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

From: Lance Phillips on 3 Dec 2009 11:57
On Nov 24, 10:46 am, MrXCell <roplopl...(a)gmail.com> wrote:
> On Nov 23, 5:36 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> 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.
From: XL Software Solutions on 8 Dec 2009 10:23
On Dec 3, 4:57 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> wrote:
> On Nov 24, 10:46 am, MrXCell <roplopl...(a)gmail.com> wrote:
>
> > On Nov 23, 5:36 pm, Lance Phillips <lgp.owl.s...(a)gmail.com> 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


 |  Next  |  Last
Pages: 1 2 3
Prev: C# Add-in and PivotTables
Next: putting a picture onto a userform without using the vba window.