Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Destination printer in BeforePrint event handler 1

Status
Not open for further replies.

Deniall

Technical User
May 15, 2011
250
Australia
For client-dictated reasons I need to prevent the users of the spreadsheet I am developing from using certain printers under certain circumstances.[ ] Obviously this requires the use of the Workbook_BeforePrint event handler.

How, inside that event handler, do I determine the destination printer that the user has selected?
 
I think I have just answered my own question:
Code:
Application.ActivePrinter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top