J Jim Rech Mar 24, 2005 #2 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
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