Supress "now printing" message
 

I have a macro that prints about 10 different worksheets in
workbook....Excel brings up 10 different "now printing" messages whe
the macro runs.

Anybody know how to suppress that message from coming up

--
Message posted from http://www.ExcelForum.com

Supress "now printing" message
 

I'm not sure if it works on a Print dialog, but have you tried
Application.DisplayAlerts = False

HTH, Greg

"jasonsweeney " wrote in
message ...
I have a macro that prints about 10 different worksheets in a
workbook....Excel brings up 10 different "now printing" messages when
the macro runs.

Anybody know how to suppress that message from coming up?


---
Message posted from http://www.ExcelForum.com/

Supress "now printing" message
 

You could try something like this

http://www.xcelfiles.com/VBA_Prt3.html

"Greg Koppel" wrote in message ...
I'm not sure if it works on a Print dialog, but have you tried
Application.DisplayAlerts = False

HTH, Greg

"jasonsweeney " wrote in
message ...
I have a macro that prints about 10 different worksheets in a
workbook....Excel brings up 10 different "now printing" messages when
the macro runs.

Anybody know how to suppress that message from coming up?


---
Message posted from http://www.ExcelForum.com/