Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing Comments
Is there a way to programmatically resize the comment
shape that is displayed? I want all of the comment to be visible without the need to Edit the comment and manually resize the shape. The ShapeRange.ScaleHeight method has a scale parameter but it does not appear that the scale can be set to auto size. Excel 2002, Win XP. TIA Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing Comments
Tom, I have code that will do this, but I can't get at it
until tomorrow. If noone else responds, check back tomorrow and I'll post a function here that autosizes the comment in the activecell. -----Original Message----- Is there a way to programmatically resize the comment shape that is displayed? I want all of the comment to be visible without the need to Edit the comment and manually resize the shape. The ShapeRange.ScaleHeight method has a scale parameter but it does not appear that the scale can be set to auto size. Excel 2002, Win XP. TIA Tom . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing Comments
You can use code similar to the following:
'============================ Sub AutosizeComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.TextFrame.AutoSize = True Next End Sub '========================= Tom Ulincy wrote: Is there a way to programmatically resize the comment shape that is displayed? I want all of the comment to be visible without the need to Edit the comment and manually resize the shape. The ShapeRange.ScaleHeight method has a scale parameter but it does not appear that the scale can be set to auto size. Excel 2002, Win XP. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
Column sizing | Charts and Charting in Excel | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Name Box sizing | Excel Discussion (Misc queries) | |||
Row Sizing | Excel Discussion (Misc queries) |