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
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
Comentários
Enviar um comentário
Obrigado pelo seu contacto.