View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
B Lynn B B Lynn B is offline
external usenet poster
 
Posts: 131
Default 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!