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
.
|