Comments Boxes

[bluebadger]

How do you keep the comment boxes the same size and shape when you are editing columns and rows.
I often add/remove rows from the spreadsheet and whenever I do the comment boxes either scrunch up so you can't see them or become really really long?

[Dave Peterson]

I don't think you can control it.

But Debra Dalgleish has some code to resize and reposition comments at:
http://contextures.com/xlcomments03.html



bluebadger wrote:
>
> How do you keep the comment boxes the same size and shape when you are
> editing columns and rows.
> I often add/remove rows from the spreadsheet and whenever I do the
> comment boxes either scrunch up so you can't see them or become really
> really long?
>
> --
> bluebadger
> ------------------------------------------------------------------------
> bluebadger's Profile: http://www.excelforum.com/member.php...o&userid=33896
> View this thread: http://www.excelforum.com/showthread...hreadid=542382

--

Dave Peterson