[A1].Comments.Add Hidden:=True "My comment"

will display just the comment indicator on the cell, and
pop up the comment like a hint when moving the mouse
pointer over the indicator.

Regards,

Dag :) -- DagOystein.Johansen AT sage.com


-----Original Message-----
Hello, I hope somone can help me out.

I am using VBA in Excel XP with Windows 2000.

I have some VBA that adds a cell comment:

[A1].AddComment MyText

Now, I would like to "AutoSize" the comment. Everything I
have tried has failed. I want to leave the comment so
that
only the cell indicator is visible.

Your example code to create a cell comment, "AutoSize"
it,
and close it, would be most appreciated. Thanks in
advance...
.