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

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.

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
wrote:

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

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.

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

I support an Excel 2003/2007 workbook for Siemens Building
Technologies and the workbook performs a lot of background functions
and does a lot of copying and pasting of data from hidden worksheets
to formatted form style sheets. This bug almost renders the entire
program useless. I would be interested to know if there is an ETA for
the fixes that will make the software work again. There is no quick
fix in my case, having 20+ sheets and hundreds of functions and
macros.

On Dec 8, 8:23*am, XL Software Solutions
wrote:
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

To date no one has received notice of an ETA for the fix.

There will be one...............in the meantime uninstall the two updates.


Gord Dibben MS Excel MVP

On Tue, 8 Dec 2009 15:00:02 -0800 (PST), Josh White
wrote:

I support an Excel 2003/2007 workbook for Siemens Building
Technologies and the workbook performs a lot of background functions
and does a lot of copying and pasting of data from hidden worksheets
to formatted form style sheets. This bug almost renders the entire
program useless. I would be interested to know if there is an ETA for
the fixes that will make the software work again. There is no quick
fix in my case, having 20+ sheets and hundreds of functions and
macros.

On Dec 8, 8:23*am, XL Software Solutions
wrote:
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

On 9 Dez., 01:46, Gord Dibben <gorddibbATshawDOTca wrote:
To date no one has received notice of an ETA for the fix.

There will be one...............in the meantime uninstall the two updates..

Gord Dibben *MS Excel MVP

On Tue, 8 Dec 2009 15:00:02 -0800 (PST), Josh White
wrote:



I support an Excel 2003/2007 workbook for Siemens Building
Technologies and the workbook performs a lot of background functions
and does a lot of copying and pasting of data from hidden worksheets
to formatted form style sheets. This bug almost renders the entire
program useless. I would be interested to know if there is an ETA for
the fixes that will make the software work again. There is no quick
fix in my case, having 20+ sheets and hundreds of functions and
macros.

On Dec 8, 8:23*am, XL Software Solutions
wrote:
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- Zitierten Text ausblenden -

- Zitierten Text anzeigen -

Gord, thanks for your information. I hope MS will fix the problem
soon.

btw. Excel 2010 Beta has the same display corruption issue.

Philipp von Wartburg
www.xlam.ch

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?
.

Has anyone heard of anything from Microsoft on this?

"RobG" wrote:
Has anyone heard of anything from Microsoft on this?

Yes; well, at least I can Google and read. See
http://support.microsoft.com/kb/973593 .

If you use userinterfaceonly to protect your sheets, nothing else need to be
done in the VBA code.

"RobG" wrote in message
...
Has anyone heard of anything from Microsoft on this?

On 6 Jan., 13:03, "Bob Umlas" wrote:
If you use userinterfaceonly to protect your sheets, nothing else need to be
done in the VBA code.

"RobG" wrote in message

...



Has anyone heard of anything from Microsoft on this?- Zitierten Text ausblenden -

- Zitierten Text anzeigen -

Microsoft has just published a hotfix for Excel 2003 (KB978908):
http://support.microsoft.com/hotfix/...908&kbln=en-us

I installed this hotfix and the screen-problem was solved :-)

Philipp von Wartburg
www.xlam.ch

"Yes; well, at least I can Google and read."

Good for you Joe. Glad you can and google and I read. I will brush
up on those high level skills. When I read that link early in
December those updates were not there so I thought I would ask on this
board....My apologies...

On Jan 6, 11:22*am, "Joe User" <joeu2004 wrote:
"RobG" wrote:
Has anyone heard of anything from Microsoft on this?

Yes; well, at least I can Google and read. *Seehttp://support.microsoft..com/kb/973593.