| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Macros in Excel 2003
I've had macros speed up considerably when I've turned screen updating
Application.ScreenUpdating = FALSE 'at beginning Application.ScreenUPdating = TRUE 'at end and turned off calculations Worksheets("Sheet1").EnableCalculation = FALSE ' at beginning Worksheets("Sheet1").EnableCalculation = TRUE ' at end HTH, Barb Reinhardt "mickey" wrote: When I am running a particular macro in Excel 2003 my PC boggs down terribly. The PC usage spikes up to 75% or more and it takes a very long time to run. It appears to be a spooling issue. Has anyone encountered this? Any suggestions? Could this be a Norton's issues? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running Macros in Excel 2003
Thanks Barb. I'll give it a try.
"Barb Reinhardt" wrote: I've had macros speed up considerably when I've turned screen updating Application.ScreenUpdating = FALSE 'at beginning Application.ScreenUPdating = TRUE 'at end and turned off calculations Worksheets("Sheet1").EnableCalculation = FALSE ' at beginning Worksheets("Sheet1").EnableCalculation = TRUE ' at end HTH, Barb Reinhardt "mickey" wrote: When I am running a particular macro in Excel 2003 my PC boggs down terribly. The PC usage spikes up to 75% or more and it takes a very long time to run. It appears to be a spooling issue. Has anyone encountered this? Any suggestions? Could this be a Norton's issues? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running macros on ALL Excel tabs | Excel Worksheet Functions | |||
| Anyone have troubles running 2003 macros in 2000 version of Excel | Excel Discussion (Misc queries) | |||
| I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
| Running macros when Excel starts up | Excel Discussion (Misc queries) | |||
| Macros running slow in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
