Hiding the 'printing' dialog box

M

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
 
B

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

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

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