possible to default?: Format Comment > Alignment > Automatic Size

[Guest]

Rather than selecting the "Automatic Size" for each cell
comment ONE AT A TIME, is it possible to set your options
so that all cell comments start out with the automatic
size feature enabled?
Thank you.

 

[David McRitchie]

The change comments at one time with a macro
http://www.mvps.org/dmcritchie/excel/ccomment.htm#resize

To catch comments and resize them when the workbook is
opened see Stephen Bullen's reply in
http://groups.google.com/groups?th=4e1723a41570510d

 

[Dave Peterson]

How about resizing them when you're done via a macro?

http://www.contextures.com/xlcomments03.html#Resize
(From Debra Dalgeish's site)