Saturday, February 06, 2010

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

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

No comments:

Post a Comment

Share on Facebook
Related Posts Plugin for WordPress, Blogger...
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.