Show All Comments using Excel VBA / Hide All Comments using Excel VBA

Submitted by Support on Sun, 02/07/2010 - 03:38

The following code is a easier way to show all comments in the Excel Spreadsheet. This comes handy when you want to view all the comments to make some decisions.

Application.DisplayCommentIndicator = xlCommentAndIndicator

Just in case you feel the sheet is littered with comments you can turn it off by using

Application.DisplayCommentIndicator = xlCommentIndicatorOnly