Show In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook. To do this we need to create what is called a "personal macro workbook" and then save it. All of the macros that we want to use in Excel will be stored within this personal macro workbook and will then be accessible by any Excel file. Steps to Make any Macro Available in All Excel Files
As you can see, this new PERSONAL.XLSB file behaves just like a regular file in the VBA window. This is where you will store any macros that you want to be able to access from all Excel files. NotesThe personal macro workbook file does NOT travel with your Excel files when you send them; this PERSONAL.XLSB file only remains on your computer for you to use. So, if you send a workbook to another person, they will not be able to access the same macros that you have unless you also put those macros in the workbook you sent. You must follow the above steps to create the personal macro workbook but, once you have created it, you can access it from any workbook on your computer by simply going to the VBA/Macro editor window (Alt + F11). As such, once it is created, adding macros to this new file is the same as adding it to any other Excel file - open any workbook, go to the VBA window, add a module to the PERSONAL.XLSB file and then add a macro. The sample file for this tutorial is empty because, remember, you cannot send the personal macro workbook file with Excel files.
Excel VBA Course - From Beginner to Expert200+ 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.) View Course Similar Content on TeachExcel Vlookup Function That Searches The Entire Workbook in Excel - UDF Copy and Paste Data using Macro VBA in Excel Get the Name of a Worksheet in Macros VBA in Excel Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel Sort Data that Doesn't Have Headers in Ascending Order in Excel Loop through a Range
of Cells in a UDF in Excel Subscribe for Weekly TutorialsBONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert 200+ Video Lessons 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 |