November 10, 2009 Security Update macro problems
 

After the Security Update for Excel 2003 and 2007 from November 10, 2009,
macros became much slower and a refresh problem started happening. What
happens is that when, through VBA, I place a value on a cell on an inactive
sheet, the cell where the value has been placed is seen in the active sheet.
This is causing some unusual behavior, as i place a lot of values in sheets
that are not active.

Does anyone have a problem like this?

November 10, 2009 Security Update macro problems
 

http://www.microsoft.com/office/comm...r=US&sloc=&p=1

Dan

"Willy Lock" wrote:

After the Security Update for Excel 2003 and 2007 from November 10, 2009,
macros became much slower and a refresh problem started happening. What
happens is that when, through VBA, I place a value on a cell on an inactive
sheet, the cell where the value has been placed is seen in the active sheet.
This is causing some unusual behavior, as i place a lot of values in sheets
that are not active.

Does anyone have a problem like this?

November 10, 2009 Security Update macro problems
 

It is known problem and has been reported.

For now just uninstall the two updates.

KB973593 and KB973475


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 10:32:01 -0800, Willy Lock
wrote:

After the Security Update for Excel 2003 and 2007 from November 10, 2009,
macros became much slower and a refresh problem started happening. What
happens is that when, through VBA, I place a value on a cell on an inactive
sheet, the cell where the value has been placed is seen in the active sheet.
This is causing some unusual behavior, as i place a lot of values in sheets
that are not active.

Does anyone have a problem like this?