April 2006
Beginner
1114 pages
98h 16m
English
customview.Show
Makes a view active. This may or may not change the display. For example, the following code switches to the Landscape view created earlier, prints the workbook, then restores the default view. Because the Landscape view includes only print settings, the appearance of the worksheets does not change.
Sub PrintLandscape( )
Dim wb As Workbook
Set wb = ThisWorkbook
' Set landscape view.
wb.CustomViews("Landscape").Show
wb.PrintOut , , , True
End SubRead now
Unlock full access