Hi Kevin or anyone else who can help me.
I've been tryint to use the information that you and Desert Piranha provided
but it apears that I need to know VB. I don't. Can you please help me by
explaining how I ca apply this information you have provided? Your help is
greatly appriciated.
:
You're welcome. Good luck.
--
Kevin Vaughn
:
Thank You Kevin, It sounds like it has possiblities.
:
Perhaps there is a way to fake it. I found this while doing the google group
search:
From: David McRitchie - view profile
Date: Thurs, Oct 21 2004 7:29 pm
Email: "David McRitchie" <
[email protected]>
Groups: microsoft.public.excel.misc
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author
Hi Sue,
Actually there was an earlier use of a triangle shape overlaying
the cell comment to change the apparent color, you might want to
check out both threads instead of just one of them.
Cell Comment indicator triangle, change color of, Stratos Malasiotis,
2000-07-08
http://google.com/[email protected]
Also check out another macro doing same thing, mainly by Dave Peterson,
2003-04-25,
http://google.com/[email protected]
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
--
Kevin Vaughn
:
One more piece of important info: I'm using Excel 2003
:
Does anyone know how I can change the color of the comment indicators in an
Excel spreadsheet so I can tell who wrote the comment. This would help me and
my secretary to be able to do our work and be able to tell who's comment it
is. We are in different lacation and can't always talk to each other on the
spur of the moment. If we can change the color of the comment indicator then
it would be simple to be able to see at a glance who's comment it is.