Comments added to Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I depend heavily on comments added to specific cells in my spreadsheets.

I find it very frustrating that the comments do not keep their shape. Some have a width of 0†and some have a width of 26†(yes, twenty-six inches!) and everything in between in the same file.

I could work so much faster if I didn’t have to stop and edit each comment to resize it to be able to read the content.

Is there a way to globally format all the comments? Is it a program bug that they don’t keep their size and shape?
 
Try this macro against a copy of your worksheet--just in case!

Option Explicit
Sub testme02()

Dim myComment As Comment

For Each myComment In ActiveSheet.Comments
myComment.Shape.TextFrame.AutoSize = True
Next myComment

End Sub

Debra Dalgleish has a bunch of sample code for working with comments at:
http://www.contextures.com/xlcomments03.html

You may find it interesting.
 
Back
Top