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

thanks.

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

yes. select Tools, Options, View tab, then change the setting for comments
to whatever you want- the indicator only will show a red triangle in the cell
with a comment

(E-Mail Removed) wrote:
>can comments be turned off...so that they don't show unless you want
>them to?
>
>thanks.

--
Mark Brindamour
mtbrindamour[AT]hotmail[dot]com


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200507/1