Question : VBA - Print Worksheets with Comments
Answered by : michael-futral
Sub PrintWorksheetsWithComments() 'Display all comments Application.DisplayCommentIndicator = xlCommentAndIndicator With ActiveSheet 'As displayed on sheet .PageSetup.PrintComments = xlPrintInPlace 'Print the active sheet .PrintOut End With
End Sub
Source : https://www.excelhowto.com/macros/print-worksheets-vba/ | Last Update : Fri, 29 Apr 22