ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comments Boxes (https://www.excelbanter.com/excel-discussion-misc-queries/88781-comments-boxes.html)

bluebadger

Comments Boxes
 

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

Comments Boxes
 
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


All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com