Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comment window size
It is possible to change the default size of the comment
window? |
#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 -- Jim Rech Excel MVP "Eddie" wrote in message ... | It is possible to change the default size of the comment | window? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customize page size | Setting up and Configuration of Excel | |||
I can't adjust the window size of an active workbook. | Excel Discussion (Misc queries) | |||
Alternative window size? | Excel Discussion (Misc queries) | |||
Alternative window size? | Excel Worksheet Functions | |||
changing comment indicator size or shape | Excel Worksheet Functions |