I've got code that includes importing data from solidworks and printing
multiple sheets. since things can tend to be wrong, i'd like the code
to bring up the print preview for a sheet, wait for the user to either
hit 'Close' or 'Print' and then continue to the next sheet...

any time i leave the preview open for more than about 10 seconds i get
a popup complaining that the server's busy, and i have the options of
'switch to' and 'retry.

i really want to get rid of this window, and it's only coming up
because the print preview is waiting for user input.

is there a property like 'WorksheetIsCurrentlyInPrintPreview' that i
could flag?

is there an event trigger that i could use? 'OnPrint'? or
'OnClosePrintPreview'?

any advice at all?


--
Milothicus
------------------------------------------------------------------------
Milothicus's Profile: http://www.excelforum.com/member.php...o&userid=15121
View this thread: http://www.excelforum.com/showthread...hreadid=378923