When I want XL to open with comment indicators visible (those little
red triangles in the corners of cells with comments) I type
Application.DisplayCommentIndicator = xlNoIndicator into the
Workbook_Open Event Procedure. If I don't want the comment indicators
then the value is xlCommentIndicatorOnly.
To me this is counterintuitive. Why have Microsoft done it this odd
way?
Ken Johnson