The change comments at one time with a macro
http://www.mvps.org/dmcritchie/excel...ent.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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ...
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.