I cant recall if there was a way to suppress messages that flash on the
screen while running a macro.
Its 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.
Im using Excel 2007.

Any suggestions are appreciated.

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

Jim Thomlinson


"h2fcell" wrote:

I cant recall if there was a way to suppress messages that flash on the
screen while running a macro.
Its 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.
Im using Excel 2007.

Any suggestions are appreciated.

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.

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"h2fcell" wrote:

I cant recall if there was a way to suppress messages that flash on the
screen while running a macro.
Its 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.
Im using Excel 2007.

Any suggestions are appreciated.