DisplayCommentIndicator Property
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