Unfortunately the pop-up box for printing cannot be prevented from being
shown by using Application.DisplayAlerts. There is a way of disabling
this, but it involves using Windows API to stops the whole of Windows
updating to the monitor, and is notoriously dangerous (ie if the code
crashes the user would never know!)

There are plenty of articles in this newsgroup that cover the APIs
should you wish to pursue, but personally I would live with this
restriction.

HTH
Simon Livings

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!