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.
Sub Display_all_Comments_in_Workbook()
Application.DisplayCommentIndicator = xlCommentAndIndicator
End Sub