Excel macro that will delete all of the comment contained within the active or current worksheet in Excel. This macro deletes only the in-cell comments in Excel.
This is a great way to quickly and effectively clean up your Excel worksheets. This saves you the hassle of deleting comments by hand and is very useful for people who make a lot of notes when developing a spreadsheet in Excel but don't want the end users to view the comments in Excel.
Sub Remove_All_Comments_From_Worksheet()
Cells.ClearComments
End Sub