how to change the style of a cell with a comment .
 

Here's a link to a similar question/thread:

http://google.com/groups?threadm=105...ttica.n et.nz

There's a line in the macro that looks like this:

..Placement = xlMove

Add this right below it so that it looks like:

..Placement = xlMove
..PrintObject = False

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

EXCEL$B!!(BNEWS wrote:

hi, glad to have the chance to make friends with you via this forum.
here is my problem.
as you know, when you add a comment to a cell,a red corner will appear to
show that there is
a comment there.
i am puzzled as to how to change the red corner, how to make to be some
other colors ,
or some other shapes instead of red or triangle.
and furthermore how i can make an image of my own style like the red corner
i mentioned above.
i mean to make how to make a cell look like diffirent from other cells ,
without coloring it or making the word in the cell in a special style.for i
dont want it to be printed out.

thank you

youngman

--

Dave Peterson