How do I automatically show all comments on a seperate worksheet?

[Guest]

How do I automatically show all comments on a seperate worksheet?
I can select the option to print the comments out on seperate worksheet or
"at the end" they call it. But can I put them, on a sererate worksheet for
me to see and review in a list. They offer to review each comment one at a
time and shuffle through them, but that takes a while and its nice to see a
suammry of all of them.

 

[Debra Dalgleish]

You can use programming to copy comments to a separate sheet, where you
could print them. There's sample code here:

http://www.contextures.com/xlcomments03.html