Comment box size

[JoeP]

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]

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]

Dave,

Thanks for the help. The macro debugs at the line

..Shape.TextFrame.AutoSize = True

Any idea why?

Joe

 

[Dave Peterson]

Is the worksheet protected?

Dave,

Thanks for the help. The macro debugs at the line

.Shape.TextFrame.AutoSize = True

Any idea why?

Joe