PDA

View Full Version : Modify default size of insert comment



Esgrimidor
07-18-2009, 12:10 PM
Modify default size of insert comment

I would like to modify in Excel 2002 the standard size of the insert comment window.

how can i do ?

I am new and just couldn't put the images.
:rotlaugh::banghead:
Thankssss

rbrhodes
07-18-2009, 02:15 PM
Hi,

A comment is a shape so:


Option Explicit
Sub CommentSize()

With Range("A1")
.ClearComments
.AddComment
End With

With Range("A1").Comment
.Shape.Width = 400
.Shape.Height = 400
.Visible = False
.Text Text:="Hello!"
End With

End Sub

Esgrimidor
07-18-2009, 04:33 PM
I'm trying and comment

thankssssss

:bow:

Esgrimidor
07-18-2009, 06:30 PM
No. No change the configuration.
Only the cell A1 appear with a bigger comment.
I would like to change the size of the comment in general.
The default value goes into the new one.
And then when we want insert a new comment it will be of the new size.

mdmackillop
07-19-2009, 05:55 AM
I don't know of any simple way to change the default comment size. By using a shortcut, you can run dr's code (slightly modified) to add a custom sized comment to any cell.

Sub CommentSize()
With ActiveCell
.ClearComments
.AddComment
End With
With ActiveCell.Comment
.Shape.Width = 400
.Shape.Height = 400
.Visible = True
End With
End Sub