Comment Box Auto-sizing
 

Existing Conditions:
Single Excel Sheet 150rx10c
Every row has at least 1 to 2 comments attached to a cell
Edit/resizing the rows and columns has trashed the sizing of the associated
comment boxes. Some are tiny some are thinned out so that no text displays etc

Help Needed:
Comprehensive way to fit all comment boxes to content (ie resize to fit like
you do with rows and columns)
This document will be edited for row/cell size regularly so a repeatable or
'permanent' auto-size would be awesome.

Really don't want to have to keep manually re-sizing a couple hundred
comment boxes so any help you can give would be greatly appreciated.

Bill

Check out the macros at Debra Dalgleish's site.

http://www.contextures.on.ca/xlcomments03.html#Resize


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 10:44:36 -0700, "Bill Davis" <Bill
wrote:

Existing Conditions:
Single Excel Sheet 150rx10c
Every row has at least 1 to 2 comments attached to a cell
Edit/resizing the rows and columns has trashed the sizing of the associated
comment boxes. Some are tiny some are thinned out so that no text displays etc

Help Needed:
Comprehensive way to fit all comment boxes to content (ie resize to fit like
you do with rows and columns)
This document will be edited for row/cell size regularly so a repeatable or
'permanent' auto-size would be awesome.

Really don't want to have to keep manually re-sizing a couple hundred
comment boxes so any help you can give would be greatly appreciated.