Dave,

Thanks for the help. The macro debugs at the line

..Shape.TextFrame.AutoSize = True

Any idea why?

Joe

"Dave Peterson" wrote:

I'm not sure you can control this, but you can reset them with a macro:

http://www.contextures.com/xlcomments03.html#Resize
from Debra Dalgleish's site.

JoeP wrote:

For some reason, the size of the comment box changes over time - not sure
why. Some boxes seem to get bigger and some boxes shrink so that you cannot
even read the text in them.
Is there a way to 'lock' the comment box size so that it does not change?
Thanks.

Joe

--

Dave Peterson