Apagar todos os comentários no Excel
Como apagar os comentários de uma folha ou livro Excel? Um é fácil, mas todos? É necessário ter conhecimentos de VBA. How to delete Excel comments, from a whorksheet or workbook? One is easy, but all? It´s necessary know VBA. VBA: Delete comments from a worksheet. Sub Remove_All_Comments_From_Worksheet() Cells.ClearComments End Sub VBA: Delete all comments from the whole workbook Sub DeleteAllComments() For Each xWs In Application.ActiveWorkbook.Sheets For Each xComment In xWs.Comments xComment.Delete Next Next End Sub https://www.extendoffice.com/documents/excel/1744-excel-remove-all-comments.html