PageSetup.PrintComments Property (Excel)
Returns or sets the way comments are printed with the sheet. Read/write XlPrintLocation.
A variable that represents a PageSetup object.
XlPrintLocation can be one of these XlPrintLocation constants.
This example causes comments to be printed as end notes when worksheet one is printed.
Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd