Print Preview slows my code?

[B Lynn B]

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!

 

[Jim Cone]

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" <[email protected]>
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!

 

[B Lynn B]

That worked beautifully - thanks so much!