S smokiibear Jul 29, 2005 #1 can comments be turned off...so that they don't show unless you want them to? thanks.
W Wm Seales Jul 29, 2005 #2 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
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
M Mark B via OfficeKB.com Jul 29, 2005 #3 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 can comments be turned off...so that they don't show unless you want them to? thanks. Click to expand... -- Mark Brindamour mtbrindamour[AT]hotmail[dot]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-new/200507/1
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 can comments be turned off...so that they don't show unless you want them to? thanks. Click to expand... -- Mark Brindamour mtbrindamour[AT]hotmail[dot]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-new/200507/1
