PageSetup.PrintComments Property (Excel)
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.
Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd