PrintComments Property

Applies To

PageSetup object.

Description

Returns or sets the way comments are printed with the sheet. Can be one of the following XlPrintLocation constants: xlPrintInPlace, xlPrintNoComments, or xlPrintSheetEnd. Read/write Long.

See Also

PrintNotes property.

Example

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

Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd