Application.DisplayCommentIndicator = xlCommentAndIndicator
Just in case you feel the sheet is littered with comments you can turn it off by using
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
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.
Just in case you feel the sheet is littered with comments you can turn it off by using
Just in case you feel the sheet is littered with comments you can turn it off by using
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
No comments:
Post a Comment