21 Ready To Use Free Excel Macros

We have been writing Excel Macros for quite a while now and we figured out they are absolutely necessary to reduce time & efforts. Most importantly, when there is a repetitive job to be done, Excel Macros come very handy. Imagine just giving some inputs & pressing a button and vow, your job is done…!! It sounds good, isn’t it?

So, we are presenting to you 21 Free Excel Macros in this post. We hope that you will be able to automate your Excel Tasks by using these simple Macros.

  1. Excel Macro To Save Workbook Before Closing
  2. Excel Macro To Save Workbook At User Selected Location
  3. Excel Macro To Save Workbook With Today’s Date
  4. Excel Macro To Save All Workbooks
  5. Excel Macro To Close All Workbooks In One Step
  6. Excel Macro To Highlight The Active Row And Column
  7. Excel Macro To Highlight The Active Cell
  8. Excel Macro To Delete All Hyperlinks From Active WorkSheet
  9. Excel Macro To Add A Duplicate Row
  10. Excel Macro To Copy Active WorkSheet To New Workbook
  11. Excel Macro To Protect A Particular WorkSheet Before Closing
  12. Excel Macro To Unprotect A Particular WorkSheet Before Opening
  13. Excel Macro To Protect WorkBook Before Closing
  14. Excel Macro To Protect All WorkSheets Before Closing
  15. Excel Macro To Unprotect All WorkSheets Before Opening
  16. Excel Macro To Delete Hidden Rows From Active WorkSheets
  17. Excel Macro To Delete Hidden Rows From All WorkSheets
  18. Excel Macro To Delete All Hidden WorkSheets In A Workbook
  19. Excel Macro To Unhide All WorkSheets In A Workbook
  20. Excel Macro To Convert All WorkSheets In A Workbook To Proper Case
  21. Excel Macro To Convert All WorkSheets In A Workbook To Upper Case

#1 Excel Macro To Save Workbook Before Closing

 

#2 Excel Macro To Save Workbook At User Selected Location

 

#3 Excel Macro To Save Workbook With Today’s Date

 

This macro saves the active workbook with a date appended to it’s name. For instance, if the workbook name is “Demo.xls”, this macro will create a new copy of this workbook and save it as “Demo_mm-yy-dd.xls”.

#4 Excel Macro To Save All Workbooks

 

#5 Excel Macro To Close All Workbooks In One Step

 

#6 Excel Macro To Highlight The Active Row And Column

 

This macro is basically an event handler for mouse double click event. When a cell is double clicked, this macro highlights the column and row of selected cell.

#7 Excel Macro To Highlight The Active Cell

 

This macro highlights the selected cell with cyan color.

#8 Excel Macro To Delete All Hyperlinks From Active WorkSheet

 

#9 Excel Macro To Add A Duplicate Row

 

#10 Excel Macro To Copy Active WorkSheet To New Workbook

 

#11 Excel Macro To Protect A Particular WorkSheet Before Closing

 

#12 Excel Macro To Unprotect A Particular WorkSheet Before Opening

 

#13 Excel Macro To Protect WorkBook Before Closing

 

#14 Excel Macro To Protect All WorkSheets Before Closing

 

#15 Excel Macro To Unprotect All WorkSheets Before Opening

 

#16 Excel Macro To Delete Hidden Rows From Active WorkSheets

 

#17 Excel Macro To Delete Hidden Rows From All WorkSheets

 

#18 Excel Macro To Delete All Hidden WorkSheets In A Workbook

 

#19 Excel Macro To Unhide All WorkSheets In A Workbook

 

#20 Excel Macro To Convert All WorkSheets In A Workbook To Proper Case

 

#21 Excel Macro To Convert All WorkSheets In A Workbook To Upper Case

 

We hope that you enjoy the excel macros posted above. You may want to look at Excel Macros posted earlier here.We would love to hear your feedback, queries and suggestions.

  1. Hi, I need your help in creating a macro for Concatenate the comments in excel sheets. Row 1 has heading and every heading has certain data. Now I want to concatenate 2nd Row data using heading from Row 1 with comma and space(, ).

    The Rows are uncertain which have or may not have data. but I don’t care about it. I just want to concatenate the rows data till last Heading(Row1).
    example: Attended Feedback Register Prospects
    Yes No Yes Maybe
    it should concatenate as : “Attended – Yes, Feedback- No, Register- Yes, Prospects- Maybe”.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">