LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print preview v page break preview SamB Excel Discussion (Misc queries) 0 November 16th 06 05:09 PM
Doing a "print preview" slows down an Excel 2003 COM addin. gordon garnsey[_2_] Excel Programming 2 October 19th 06 02:42 AM
Differentiate between 'Print' and 'Print Preview' in VBA code Mattantaliss Excel Programming 4 April 17th 06 09:31 PM
Code before Print but not Print Preview widemonk Excel Programming 1 November 14th 05 01:48 PM
Resuming code after closing a print preview DarrenW Excel Programming 1 July 21st 03 02:54 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"