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

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.

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

newmember wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html