Print Preview slows my code?
in [Programming]
|
From: B Lynn B on 27 May 2010 16:31 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!
From: Jim Cone on 27 May 2010 16:47 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" <BLynnB(a)discussions.microsoft.com> wrote in message news:A3E3574B-A9B4-4183-A561-6B7701EF566E(a)microsoft.com... 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!
From: B Lynn B on 27 May 2010 19:47 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" <BLynnB(a)discussions.microsoft.com> > wrote in message news:A3E3574B-A9B4-4183-A561-6B7701EF566E(a)microsoft.com... > 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! > . >
|
Pages: 1 Prev: Pass Parameter from Excel to SharePoint Next: Remove add-in |