Tom & Jim,

Thanks for the suggestions. Like I mentioned to Trevor, I am just starting
out on this VBA thing and don't know if my continued head beating is worth
the 1 or 2 pts. to get it to run as requested in the assignment.

Thanks again,

Peter

"Jim" wrote:

If you don't want it to do print preview, change the line that says Preview
= True to Preview = False

"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,