You can use

Activesheet.PrintPreview

--
Regards,
Tom Ogilvy


"mikeburg" wrote in
message ...

Thanks for the response. Can't seem to get it to work.

Is there a way to set the output to a dummy printer where nothing
prints?

thanks a million.. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=490604