ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Increasing comment box size? (https://www.excelbanter.com/excel-discussion-misc-queries/161891-increasing-comment-box-size.html)

jmumel

Increasing comment box size?
 
I have used a macro to standardize the size of the boxes after they initially
changed due to sorting, inserting, etc. What I can't figure out is how to
increase the default size of the box. I have e-mail addresses in a ton of
them so I want to make the boxes longer so they are on 1 line. Another set I
want to make longer and real skinny.
I am a novice, so any help would be great appreciated but it needs to be
super basic. : ) Thanks!!!

FSt1

Increasing comment box size?
 
hi
a little out of my area but see debra's site. I think she is our resident
expert on comments.
http://www.contextures.com/xlcomments03.html#Reset

regards
FSt1

"jmumel" wrote:

I have used a macro to standardize the size of the boxes after they initially
changed due to sorting, inserting, etc. What I can't figure out is how to
increase the default size of the box. I have e-mail addresses in a ton of
them so I want to make the boxes longer so they are on 1 line. Another set I
want to make longer and real skinny.
I am a novice, so any help would be great appreciated but it needs to be
super basic. : ) Thanks!!!



All times are GMT +1. The time now is 04:03 PM.

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