Suppress print messages

H

h2fcell

I can’t recall if there was a way to suppress messages that flash on the
screen while running a macro.
It’s something other than Application.ScreenUpdating = False
When I use Worksheets("Sheet1").PrintOut, in my macro, a message flashes
very quickly.
Probably something like “sending to printerâ€.
I would like to turn this messaging off during print.
I’m using Excel 2007.

Any suggestions are appreciated.
 
J

Jim Thomlinson

I don't think you can turn that message off. I have never really tried though
as I prefer that my users know that their print job was actually submitted.
Perhaps your users are different but mine would hit the button 3 or 4 times
until they hear the printer start printing pages.
 
H

h2fcell

Sorry I didn't go into too much details before. My macro doen't ask the user
to print, it's supposed to print a sheet automatically at a certain time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top