View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Comment Notations

You need to use VBA.

See http://www.contextures.com/xlcomments03.html#Indicator for a solution.

"Pippercat" wrote:

Excel 2007

A friend at work wonders if there is a way to print the little red triangle
that appears in the upper righthand corner of cells when a comment is
attached. We've searched and found how to print comments, but she just wants
the "notation" of a comment to print rather than the whole comment. She uses
the comments to let herself know when she's completed a task associated with
a cell's information - that is why she only needs the notation to print.

Thank you for your help!

Pippercat