Printing Options(VB.Net)
- Setting Print Page.
- Setting Print Margins.
- Setting Print Header/Footer.
- Setting Print Sheet.
- Setting Page Break.
- Setting Print Page
-
set print options for pages
'set landscape orientation
workBook.PrintLandscape = True
'fit page
workBook.PrintScaleFitToPage = True
'fitToWidth
workBook.PrintScaleFitHPages = 1
'FitHeight
workBook.PrintScaleFitVPages = 2
'set paper size
workBook.setPrintPaperSize(11906, 16838) 'A4
'auto number
workBook.PrintAutoPageNumbering = True
- Setting Print Margins
-
set print options for margins
workBook.PrintLeftMargin = 0.7
workBook.PrintTopMargin = 0.75
workBook.PrintRightMargin = 0.7
workBook.PrintBottomMargin = 0.75
workBook.PrintHeaderMargin = 0.3
workBook.PrintFooterMargin = 0.3
workBook.PrintHCenter = True
workBook.PrintVCenter = False
- Setting Print Header/Footer
-
set print options for headers/footers
MS Link(Formatting and VBA Codes for Headers and Footers)workBook.PrintHeader = "&L&G"
workBook.PrintFooter = "&CPage &P of &N"
- Setting Print Sheet.
-
set print options for sheet
workBook.PrintArea = "Sheet1!$A$1:$AG$787"
workBook.PrintTitles = "Sheet2!$M:$M,Sheet2!$11:$11"
workBook.PrintGridLines = False
workBook.PrintNoColor = True
workBook.PrintRowColHeading = True
- Setting Page Break.
-
set page/row/column break for printing
'add page break at B2
workBook.addRowPageBreak(2)
workBook.addColPageBreak(2)