PrintComments Property Example
This example causes comments to be printed as end notes when worksheet one is printed.
Worksheets(1).PageSetup.PrintComments = xlPrintSheetEnd