Delete All Comments in a Worksheet in Excel Macro
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.
Where to install the macro: Module
Excel Macro to Delete All Comments in a Worksheet
Sub Remove_All_Comments_From_Worksheet()
Cells.ClearComments
End Sub
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: Display all formulas instead of their output values. This allows you to quickly troubles...
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Tutorial: How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is ...
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Macro: Sort data that doesn't have headers in ascending order in Excel with this macro. This is a...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.
Tutorial: Display all formulas instead of their output values. This allows you to quickly troubles...
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)