| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Preview slows my code?
Running 2007 Prof+. I have a block of code that runs (yes with
screenupdating = false) to loop through a collection of cells and hide some rows, show some rows and perform row-height autofit on the ones showing. When I open the file, all is well - code runs nice and fast. However, once I've done a PrintPreview, code slows drastically and remains slow for as long as I have the file open. If I close and reopen the file, now it's fast again. SO. Is there some object I can get at with code to reset it to the before-print-preview state? Thanks for whatever help you have to offer! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print Preview slows my code?
Try turning off the display of page breaks... ActiveSheet.DisplayPageBreaks = False -- Jim Cone Portland, Oregon USA (Special Sort... http://www.contextures.com/excel-sort-addin.html) "B Lynn B" wrote in message ... Running 2007 Prof+. I have a block of code that runs (yes with screenupdating = false) to loop through a collection of cells and hide some rows, show some rows and perform row-height autofit on the ones showing. When I open the file, all is well - code runs nice and fast. However, once I've done a PrintPreview, code slows drastically and remains slow for as long as I have the file open. If I close and reopen the file, now it's fast again. SO. Is there some object I can get at with code to reset it to the before-print-preview state? Thanks for whatever help you have to offer! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print Preview slows my code?
That worked beautifully - thanks so much!
"Jim Cone" wrote: Try turning off the display of page breaks... ActiveSheet.DisplayPageBreaks = False -- Jim Cone Portland, Oregon USA (Special Sort... http://www.contextures.com/excel-sort-addin.html) "B Lynn B" wrote in message ... Running 2007 Prof+. I have a block of code that runs (yes with screenupdating = false) to loop through a collection of cells and hide some rows, show some rows and perform row-height autofit on the ones showing. When I open the file, all is well - code runs nice and fast. However, once I've done a PrintPreview, code slows drastically and remains slow for as long as I have the file open. If I close and reopen the file, now it's fast again. SO. Is there some object I can get at with code to reset it to the before-print-preview state? Thanks for whatever help you have to offer! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| Doing a "print preview" slows down an Excel 2003 COM addin. | Excel Programming | |||
| Differentiate between 'Print' and 'Print Preview' in VBA code | Excel Programming | |||
| Code before Print but not Print Preview | Excel Programming | |||
| Resuming code after closing a print preview | Excel Programming | |||
Hybrid Mode
