I'm not sure I understand. If you Print Preview, I guess Excel assumes you
want to look at the preview. Hence you (or the user) determine when you've
seen enough.

As far as I know, this will have to be a manual intervention.

Regards


"Pb" wrote in message
...
Thanks Trevor,

But it still will not "close" after the preview.

"Trevor Shuttleworth" wrote:

sheets(1).printpreview
activesheet.printpreview

Regards

Trevor


"Pb" wrote in message
...
I have a macro that ends with a print preview of the worksheet. I can
not
seem to get the macro to record the close on the print preview. Any
suggestions - be careful, I am very new at this vb stuff.

Thanks,