Is the worksheet protected?
JoeP wrote:
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
--
Dave Peterson