How To Work With Worksheet Comments In Excel 2011 For Mac
- How To Work With Worksheet Comments In Excel 2011 For Mac Free
- How To Work With Worksheet Comments In Excel 2011 For Mac Download
How To Work With Worksheet Comments In Excel 2011 For Mac Free
A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Create chart in new worksheet. Select cells with comments.
How To Work With Worksheet Comments In Excel 2011 For Mac Download
While you can't set the default line style for comment boxes, you can use a macro to change all the comment lines on a worksheet to the format you like. Sub FormatCommentLines Dim oComment As Comment, i As Integer For Each oComment In ActiveSheet.Comments Selection.ShapeRange.Line.Weight = 3# Selection.ShapeRange.Line.DashStyle = msoLineRoundDot Selection.ShapeRange.Line.Style = msoLineSingle Selection.ShapeRange.Line.Transparency = 0# Selection.ShapeRange.Line.Visible = msoTrue Selection.ShapeRange.Line.ForeColor.SchemeColor = 14 Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255) Next End Sub I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.