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

Hi Sal21,

I believe that you would have to use API calls.

Try googling for 'Function LockWindowUpdate'


---
Regards,
Norman



"sal21" <[email protected]> wrote in message
news:[email protected]...
> 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....
>

http://tinyurl.com/8f3dj

--
Regards,
Tom Ogilvy

"sal21" <[email protected]> wrote in message
news:[email protected]...
> 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....
>