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