Screen updating

Topic

New Reply

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Even with the above settings, when I print, I still see the “sent to printer” dialogue popup. Is there any way to suppress this when printing.

I’m sure that this never used to happen, but in altering code recently, it is now appearing and I cannot figure out why.

Reply | Quote

Replies

That’s not an Excel dialog but a Windows dialog. To suppress it:
– Open the Printers and Fax Devices control panel.
– Select File | Server Properties…
– Activate the Advanced tab.
– Clear the check boxes “Show informational notifications for local printers” and “Show informational notifications for network printers”.
– Click OK.

Reply | Quote

I must be imagining that they never previously appeared, as I don’t think those settings have been changed.

I would’nt want to turn them off completely, it’s just that I try to avoid things flashing constantly on screen when a procedure is running.

Thanks anyway.

Reply | Quote