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