Thread: Sizing Comments
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ulincy[_2_] Tom Ulincy[_2_] is offline
external usenet poster
 
Posts: 4
Default 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