|
Posted to microsoft.public.excel.programming
|
|
|
copying comments in excel to a separate worksheet
Have a look here
http://www.contextures.com/xlcomment...ml#CopyToSheet
Mike
"dmars" wrote:
Hi,
Can anyone help me with the code needed to copy all my comments to another
worksheet(history log) in the same workbook? Comments will need to be
appended to the worksheet as they are added. I was able to find code that
would copy all coments to a new sheet but everytime I run it it creates a new
sheet and replaces the file. It doesn't add to the existing worksheet. I am
trying to create a history log of all comments. When a comment is deleted
from the spreadsheet it should remain on the history log and if a comment is
added it should append to the worksheet.
Thanks for your help.
|