Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintPreview slows Code Execution
Hi,
I have a workbook which contains some fairly complex subs but they run fast enough for normal needs. However, after running a small sub that just sets the PrintArea and does a PrintPreview , code execution becomes exceeedingly slow. Any ideas ? Thanks, Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintPreview slows Code Execution
Don,
afaik: to speed up your macro EITHER use: worksheets(x) .DisplayAutomaticPageBreaks = False it's a hidden property of the worksheet object (only shows up if hidden properties are displayed in the object browser) you dont need to repeat that.. OR use: worksheets(x) .DisplayPageBreaks=false you DO need to repeat that line after each print or printpreview -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Hi, I have a workbook which contains some fairly complex subs but they run fast enough for normal needs. However, after running a small sub that just sets the PrintArea and does a PrintPreview , code execution becomes exceeedingly slow. Any ideas ? Thanks, Don |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintPreview slows Code Execution
"Don Lloyd" wrote in message
... I have a workbook which contains some fairly complex subs but they run fast enough for normal needs. However, after running a small sub that just sets the PrintArea and does a PrintPreview , code execution becomes exceeedingly slow. Hi Don, Try setting Worksheets("MySheet").DisplayPageBreaks = False for all worksheets affected. This stops Excel from recalculating the page breaks each time you do something that changes them and can improve performance in some cases. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintPreview slows Code Execution
Rob and KeepItCool,
Thanks very much. Oh and Rob, personal thanks for the Code Cleaner - been using it for years ! regards, Don "Rob Bovey" wrote in message ... "Don Lloyd" wrote in message ... I have a workbook which contains some fairly complex subs but they run fast enough for normal needs. However, after running a small sub that just sets the PrintArea and does a PrintPreview , code execution becomes exceeedingly slow. Hi Don, Try setting Worksheets("MySheet").DisplayPageBreaks = False for all worksheets affected. This stops Excel from recalculating the page breaks each time you do something that changes them and can improve performance in some cases. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code execution has been interrupted | Excel Discussion (Misc queries) | |||
Code slows on subsequent run | Excel Programming | |||
VBA code slows to a snails crawl when screen saver activated | Excel Programming | |||
VBA: Pausing Code Execution | Excel Programming | |||
Pausing code execution | Excel Programming |