software

Hi,
I have created a button that prints out 3 worksheets.
when this button is pressed, the 'Printing' dialog box flashes up for
each one.

is there a way of hiding/supressing this?thanks,
Matt--
matpj
------------------------------------------------------------------------
matpj's Profile: www.excelforum.com/member.php...oamp;userid=21076
View this thread: www.excelforum.com/showthread...hreadid=541491
Hi Matt,

Try quot;application.displayalerts = falsequot; before your code amp;
quot;application.displayalerts = truequot; after your code.

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

hth
Rob Brockett
NZ
always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=541491
thanks for the reply.
that didn't do the job, unfortunately.
I've looked at that link as well, but there doesn't seem to be anything
on there that solves the problem either..--
matpj
------------------------------------------------------------------------
matpj's Profile: www.excelforum.com/member.php...oamp;userid=21076
View this thread: www.excelforum.com/showthread...hreadid=541491
hi Matt,

Sorry I couldn't help. I've done a quick Google amp; found one
explanation/solution though, hopefully this helps:

tinyurl.com/rmk7e

(I haven't tried this but the post by Stratos was quoted a couple of
times by other posters so I assume it works.)

hth
Rob Brockett
NZ
always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=541491