View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Excel Cell Comments

Depending on overall needs maybe replace 'my name' with 'new name' in
comments.

See Debra Dalgleish's routine and more about comments here -
http://www.contextures.com/xlcomments03.html#OldName

I notice the original bold format of the username is lost but the code could
be adapted to re-embolden the username if required.

Also in the example, when done the username in tools/option can be reset to
original with username in the status bar continuing to display the new name
as replaced in the comments, if required.

Regards
Peter T

"kirkm" wrote in message
...
If I run the cursor over a commented cell, the Status bar
at the bottom of the screen says 'Cell xx commented by' and my name

Can I remove my name ?

Thanks - Kirk