Hiding the 'printing' dialog box

[matpj]

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

 

[broro183]

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...

 

[matpj]

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..

 

[broro183]

hi Matt,

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

http://tinyurl.com/rmk7e

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

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