PageSetup.PrintComments Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns or sets the way comments are printed with the sheet. Read/write XlPrintLocation.

expression .PrintComments

expression A variable that represents a PageSetup object.

XlPrintLocation can be one of these XlPrintLocation constants.

xlPrintInPlace

xlPrintNoComments

xlPrintSheetEnd

This example causes comments to be printed as end notes when worksheet one is printed.

Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd
Show: