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 he

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