Hi all!
I have an existing workbook with approx 30 worksheets and over 50 threaded comments (ie not the legacy Notes from previous version of excel) scattered throughout the various 30 odd worksheets. I would like to extract all the threaded comments from all worksheet into a separate worksheet for reference.
I managed to get the following VBA code off the contextures.com site which works perfectly fine for extracting all threaded comments from 1 active sheets
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
Any excel VBA gurus able to assist and let me know if there is any way to modify the above code to enable it to extract all threaded comments from all worksheets in the workbook?
Thank you so much in advance. Everything else I found through google is only for the legacy Note features and does not work for the new "threaded comments" features.
Bookmarks