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,