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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com