If you want to save your macros to be able to use them in any Excel file you open, you will need to save them to your PERSONAL.XLSB file. This is a hidden file that is open and running in the background anytime you have an excel file open. So if you save a macro to this file you will always be able to run your macro.
- Open the Visual Basic Editor (Alt +F11)
- In the Project Explorer window on the left you will see a list of VBA projects. This is where you want to select the PERSONAL file instead of your current workbook. Click VBAProject(PERSONAL).
- Click Insert on the top tool bar and select module. You will see a new window popup in the Visual Basic Editor. This will be where you will paste the macros in future posts.
- After you paste the macro into the new module, click Save, and Close the Visual Basic Editor.