DisplayCommentIndicator Property [Excel 2003 VBA Language Reference]
Returns or sets the way cells display comments and indicators. Can be one of the following XlCommentDisplayMode constants: xlNoIndicator, xlCommentIndicatorOnly, or xlCommentAndIndicator. Read/write Long.
Example
This example hides cell tips but retains comment indicators.
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
Applies to | Application Object