PersonalViewPrintSettings Property

Microsoft Excel Visual Basic

PersonalViewPrintSettings Property

       

True if print settings are included in the user's personal view of the shared workbook. Read-write Boolean.

Example

This example removes print settings and filter and sort settings from the user's personal view of workbook two.

With Workbooks(2)
    .PersonalViewListSettings = False
    .PersonalViewPrintSettings = False
End With