Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Slowing Down after Macros Added
I am a newbie to VBA.
I notice that my excel file seems to be slowing down when saving after adding some simple macros for sorting data. Are there some guidlines to minimize the impact of Macros slowing down excel?? Like screenupdating=false etc. Thanks in advance, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Slowing Down after Macros Added
To answer your specific question, you can bracket your macro code with:
Application.ScreenUpdating = False Application.ScreenUpdating = True I hedge because there could be other reasons why things are slowing down but you don't provide any details about what is happening when you save. HTH Otto "Lee" wrote in message ... I am a newbie to VBA. I notice that my excel file seems to be slowing down when saving after adding some simple macros for sorting data. Are there some guidlines to minimize the impact of Macros slowing down excel?? Like screenupdating=false etc. Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is path name added to active cell when Excel file is saved? | Excel Discussion (Misc queries) | |||
View zoom slowing opening of the file | Excel Discussion (Misc queries) | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
My macros are slowing down. | Excel Programming | |||
My macros are slowing down. | Excel Programming |