PageSetup.PrintComments (Excel)

Returns or sets the way comments are printed with the sheet. Possible return 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