Re: Hiding the 'printing' dialog box

Giganews Newsgroups
Subject: Re: Hiding the 'printing' dialog box
Posted by:  broro183 (broro183.27oxta_1147431001.0247@excelforum-nospam.com)
Date: Fri, 12 May 2006

Hi Matt,

Try "application.displayalerts = false" before your code &
"application.displayalerts = true" after your code.

Other tips you may find handy for printing can be seen on Ron Debruin's
page:
http://www.rondebruin.nl/print.htm

hth
Rob Brockett
NZ
always learning & the best way to learn is to experience...

--
broro183
------------------------------------------------------------------------
broro183's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=30068
View this thread:http://www.excelforum.com/showthread.php?threadid=541491

Replies

In response to

Hiding the 'printing' dialog box posted by matpj on Fri, 12 May 2006