Hide all comments in a workbook
How to hide 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 Hide_all_Comments_in_a_Workbook()
'hide all comment in a workbook in which this VBA code is written in
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End Sub
EXPLANATION
This tutorial explains and provides step by step instructions on how to hide all comments in a workbook using the Excel and VBA methods.
This tutorial explains and provides step by step instructions on how to hide all comments in a workbook using the Excel and VBA methods.
Excel Methods: Using Excel you can hide all comments in a workbook with the ribbon option.
VBA Methods: Using VBA you can hide all comments in a workbook where the VBA code is written.