We have a spreadheet that was created by a former member of the
department. When comments are hovered over we get something like

cell c21 commented by Fred Smith

appearing on the status bar

I think there should be a simple macros to changes all these comment to
something like.

cell c21 commented by Performance Review

eg to change fred smith to Performance Review

Thanks in advance

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535520

Debra Dalgleish has a macro solution here...
http://www.contextures.on.ca/xlcomments03.html
"Replace Old Name in Comments"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(free excel add-ins)

"Dav"wrote in message
We have a spreadheet that was created by a former member of the
department. When comments are hovered over we get something like
cell c21 commented by Fred Smith
appearing on the status bar
I think there should be a simple macros to changes all these comment to
something like.
cell c21 commented by Performance Review
eg to change fred smith to Performance Review
Thanks in advance
Dav