You can do this with programming. There's sample code he

http://www.contextures.com/xlcomment...ml#CopyToSheet

IM_CRice wrote:
Hello: I want to save my comments in a worksheet format to view. I know how
to print the comments, but I actually need to capture them in a cell format.
Thus, taking them from the comment format and inserting it into a cell in a
worksheet. How would I accomplish this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html