How to delete all comments and notes from all worksheets in Excel.
This works with old style "notes" and new "comments" and it does not matter if they are hidden or visible.
For Each ws In Worksheets: ws.Cells.ClearComments: Next Ws
Comments in Excel (Microsoft)