Comments Author?

  • Thread starter Thread starter Dav
  • Start date Start date
D

Dav

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
 
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
 
Back
Top