Edit

Share via

CustomView.PrintSettings property (Excel)

  • Article

True if print settings are included in the custom view. Read-only Boolean.

Syntax

expression.PrintSettings

expression A variable that represents a CustomView object.

Example

This example creates a list of the custom views in the active workbook and their print, row, and column settings.

With Worksheets(1) 
 .Cells(1,1).Value = "Name" 
 .Cells(1,2).Value = "Print Settings" 
 .Cells(1,3).Value = "RowColSettings" 
 rw = 0 
 For Each v In ActiveWorkbook.CustomViews 
 rw = rw + 1 
 .Cells(rw, 1).Value = v.Name 
 .Cells(rw, 2).Value = v.PrintSettings 
 .Cells(rw, 3).Value = v.RowColSettings 
 Next 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.