PageSetup.PrintComments Property

Excel Developer Reference

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

Syntax

expression.PrintComments

expression   A variable that represents a PageSetup object.

Remarks

XlPrintLocation can be one of these XlPrintLocation constants.
xlPrintInPlace
xlPrintNoComments
xlPrintSheetEnd

Example

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

Visual Basic for Applications
  Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd

See Also