Comment window size
 

It is possible to change the default size of the comment
window?

You cannot change the size of the default comment but you can use a macro to
create a comment and change its size:

Sub NewComment()
On Error Resume Next
With ActiveCell.AddComment.Shape
.Width = 100
.Height = 60
.Visible = msoTrue
.Select
End With
End Sub


--
Jim Rech
Excel MVP
"Eddie" wrote in message
...
| It is possible to change the default size of the comment
| window?