Show all comments in a workbook
How to show all comments in a workbook using the Excel and VBA methods
Review tab > Comments group > Click Show All Comments
| 1. Select the Review. |  |
| 2. Click Show All Comments in the Comments group. |  |
Sub Show_all_Comments_in_a_Workbook()
'show all comment in a workbook in which this VBA code is written in
Application.DisplayCommentIndicator = xlCommentAndIndicator
End Sub
EXPLANATION
This tutorial explains and provides step by step instructions on how to show all comments in a workbook using the Excel and VBA methods.
This tutorial explains and provides step by step instructions on how to show all comments in a workbook using the Excel and VBA methods.
Excel Methods: Using Excel you can show all comments in a workbook with the ribbon option.
VBA Methods: Using VBA you can show all comments in a workbook where the VBA code is written.