Excel Forum
Excel VBA Course
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.)

View Course



Add Background Photos / Images to Comments in Excel
- Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature ...
Add Comments to Cells with an Excel Macro
- Add comments to cells in Excel with this macro. This allows you to quickly and easily add a comment to any cell wit ...
Automatically Highlight the Active or Selected Cell
- This macro will highlight the active cell in any excel spreadsheet with a color selected in the code. This means th ...
Create an Index / Table of Contents worksheet
- To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and name it "Index" 2) Open ...
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 mac ...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
- Delete a comment in Excel with this macro. You can permanently remove or delete a specific comment or many comments ...
Delete Empty or 'Broken' Named Ranges (#REF!)
- This macro will delete named ranges which refer to empty or #REF! ranges. This means that if a named range has been ...
Delete Hidden Rows in a Workbook
- This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only d ...
Delete Hidden Worksheets
- This macro will delete all hidden worksheets within a workbook. When you run this macro a warning window will pop ...
Delete Multiple Named Ranges Quickly
- This macro will allow you to delete multiple named ranges very quickly. When you run this macro, a message box will ...
Display or Show all of the Comments within an Entire Excel Workbook
- This macro in Excel will display all of the comments within the entire Excel workbook. This means that all of the c ...
Hide Comments in Excel Completely - Even Indicators Will not Appear
- Hide all comments in an Excel workbook. No indicators will be displayed and comments will not appear when you hover ...
Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
- Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be a ...
Hide Specific Comments in Excel - Comments Will Still Display on Hover
- Hide specific comments in Excel with this macro. Comments are still visible on hovering over the cell that contain ...
Highlight the Column of the Selected Cell
- This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid ...
Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active ce ...
Highlight the Row of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the row of the active cell with a s ...
List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
- List all of the named ranges in a workbook in Excel and the corresponding values stored within every named range. ...
Macro to add a New Line to Message Box Pop-up Windows in Excel
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same t ...
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This m ...
Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a pa ...
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
- Excel macro that will remove/delete all of the comments from an entire Excel workbook. This means that this macro ...
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
- This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment ...