PageSetup.PrintComments procedure builder

PageSetup.PrintComments (Excel)

Returns or sets the way comments are printed with the sheet.

Possible Values are xlPrintInPlace - Comments will be printed where they were inserted on the worksheet, xlPrintNoComments - Comments will not be printed, xlPrintSheetEnd - Comments will be printed as end notes at the end of the worksheet.
Worksheets("Sheet1").PageSetup.PrintComments = xlPrintInPlace