can comments be turned off

S

smokiibear

can comments be turned off...so that they don't show unless you want
them to?

thanks.
 
W

Wm Seales

Tools > Options > View
gives you 3 choices.


Also see DisplayCommentIndicator Property
in Excel's Help.


example of code:

Dim Cmt As Comment

For Each Cmt In ActiveSheet.Comments
Cmt.Visible = False
Next


etc
 
Top