Display or Show all of the Comments within an Entire Excel Workbook

Add to Favorites

This macro in Excel will display all of the comments within the entire Excel workbook. This means that all of the comments in the workbook will be visible without you having to hover over the cell that contains the comment. This is a great macro to use to find out where all of the comments in a worksheet or workbook are located and also to quickly read the comments within an Excel workbook. This is especially helpful when you receive a workbook from an outside source and are not sure where all of the comments are located within the workbook.

This macro achieves the same result as if you had chosen to view or display all of the comments in the workbook from the regular Excel menu.

Where to install the macro:  Module

Excel Macro to Display or Show all of the Comments within an Entire Excel Workbook

Sub Display_all_Comments_in_Workbook()

Application.DisplayCommentIndicator = xlCommentAndIndicator

End Sub





Similar Content on TeachExcel
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
Macro: Excel macro that will remove/delete all of the comments from an entire Excel workbook....
Get Text from Comments in Excel Including the Author of the Comment - UDF
Macro: Output all text from a cell comment, including comment author, with this UDF in Excel. Thi...
Change the Default Number of Worksheets Created in a New Excel Workbook
Tutorial: Learn how to change the number of worksheets that are in new Excel workbooks. Excel work...
Print Comments in Excel
Tutorial: How to print the comments in a worksheet when you print from Excel. This includes how to p...
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
Macro: This macro in Excel allows you to display or show a particular comment in Excel. This will...
Get Comment Text from Cell Comments in Excel - UDF
Macro: This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is ...



How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

  4. On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  8. Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.

  9. You are now ready to run the macro.


Similar Content
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
Macro: Excel macro that will remove/delete all of the comments from an entire Excel workbook....
Get Text from Comments in Excel Including the Author of the Comment - UDF
Macro: Output all text from a cell comment, including comment author, with this UDF in Excel. Thi...
Change the Default Number of Worksheets Created in a New Excel Workbook
Tutorial: Learn how to change the number of worksheets that are in new Excel workbooks. Excel work...
Excel Forum