VBA – Print Worksheets with Comments

The solution for “VBA – Print Worksheets with Comments” can be found here. The following code will assist you in solving the problem.

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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts