Thread: Sizing Comments
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pk pk is offline
external usenet poster
 
Posts: 27
Default 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

.