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: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=541491

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...o&userid=30068
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=541491

hi Matt,

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

http://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 & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=541491