| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert 13.11.2009 general to 13/11/2009 date, how to | Excel Worksheet Functions | |||
| Update 2009 dates to 2010 dates | Excel Discussion (Misc queries) | |||
| how do i enter 16-22 november, 2009 as a date in excel 2003 | Excel Discussion (Misc queries) | |||
| How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 | Excel Discussion (Misc queries) | |||
| How can I update the Employee Absence Schedule template to 2009? | Setting up and Configuration of Excel | |||
Linear Mode
