ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to Disabling Printing Notification Dialog Boxes in Windows IN VBA (https://www.excelbanter.com/excel-programming/341811-how-disabling-printing-notification-dialog-boxes-windows-vba.html)

sal21

how to Disabling Printing Notification Dialog Boxes in Windows IN VBA
 
is possible....?

In effect with a mcaro for Excel i print 45 sheets present into wbook
and the printing dialogo box flashing for all 45 sheets....


Norman Jones

how to Disabling Printing Notification Dialog Boxes in Windows IN VBA
 
Hi Sal21,

I believe that you would have to use API calls.

Try googling for 'Function LockWindowUpdate'


---
Regards,
Norman



"sal21" wrote in message
oups.com...
is possible....?

In effect with a mcaro for Excel i print 45 sheets present into wbook
and the printing dialogo box flashing for all 45 sheets....




Tom Ogilvy

how to Disabling Printing Notification Dialog Boxes in Windows IN VBA
 
http://tinyurl.com/8f3dj

--
Regards,
Tom Ogilvy

"sal21" wrote in message
oups.com...
is possible....?

In effect with a mcaro for Excel i print 45 sheets present into wbook
and the printing dialogo box flashing for all 45 sheets....





All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com