I'm using the default 'Edit Comment' Excel function to build them all.
I set the size manually cropping all the extraneous space so the area of the
comment is only aruond the text I want.
Thinking that I'm done, I continue doing development, modifying macros for
other sections. However, when I come back to some of the cells that I've
inserted comments for, I notice that the comment field grows, esp if after
i've 'corrected' the size of the comment field, I write a value to the cell.
Is there any way I can fix the size of the comment field so that it will
keep from doing this ? Or do I have to write a custom macro / form to handle
this ?
Thanks,
Chad
1. after formatting the comments, create and run a macro to read the
dimensions of each comment and store them in a public array.
2. create another macro to read the public array and apply the dimensions to
each comment
If the "evil force" attacks, you just run the second macro to re-establish
the dimensions of each comment. The following is an example of how to read
(or write) comment dimensions:
Sub readum()
Dim c As Comment
For Each c In ActiveSheet.Comments
x = c.Shape.Width
y = c.Shape.Height
MsgBox (x & " by " & y)
Next
End Sub
--
Gary's Student
Best regards
John
"Gary''s Student" <GarysS...@discussions.microsoft.com> wrote in message
news:71059548-800A-4D2F...@microsoft.com...
Sounds like the most painless way to go ... I got something like 30 odd
comments ..
I've seen the "evil force" activated when adding and/or deleting rows.
Today I found all of my carefully sized comments messed up after
adding some rows.
If using "Freeze Panes", this also affects the appearance of comments
that straddle the frozen line(s).
It looks like I'll be resorting to the "code clamp" - forcibly
restoring comment size and location in code.
FWIW...
tbone