Print Tab


Printing options

microsoft excel docs
Application.Options.PrintDraft = False 
Application.Options.UpdateFieldsAtPrint = False
Application.Options.UpdateLinksAtPrint = False
Application.Options.MapPaperSize = False
Application.Options.PrintBackground = False
ActiveDocument.PrintPostScriptOverText = False
Application.Options.PrintReverse = False

Include with Document

microsoft excel docs
Application.Options.PrintProperties = False 
Application.Options.PrintFieldCodes = False
Application.Options.PrintXMLTag = False
Application.Options.PrintHiddenText = False
Application.Options.PrintDrawingObjects = False
Application.Options.PrintBackgrounds = False

Options for current document only

microsoft excel docs
ActiveDocument.PrintFormsData = False 

Other

microsoft excel docs
Application.Options.DefaultTray = "Use printer settings" 

Options for Duplex printing

microsoft excel docs
Application.Options.PrintEvenPagesInAscendingOrder = False 
Application.Options.PrintOddPagesInAscendingOrder = False

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext