I don't want the entire comment bold, just the user name in each successive
line anytime a change is made to the cell.
EXAMPLE
<BOLDChad</BOLD dd/mmm/yy hh:mm
Comment note

<BOLDChad</BOLD dd/mmm/yy hh:mm
2nd Comment note

etc


"bgeier" wrote:


I did that intentionally to show what is the latest comment.
If you want the whole comment to show bold, change the last line before
the "End With" to true

.Shape.TextFrame.Characters(Len(Username) + 1).Font.Bold =
False --- Change to true

This will make the entire comment Bold.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=543465