Macros are stored in the Personal Macro Workbook, which is a hidden workbook that is automatically opened whenever you start Excel. The workbook is saved in your Documents folder as Personal.xlsb. You can view the macros stored in the Personal Macro Workbook by opening the workbook in Excel.
On Windows 10, Windows 7, and Windows Vista, the Personal.xlsb file is located in the XLSTART folder in the following locations:
In this way, if you can’t open it, you have not created any personal macros yet. So, first, create it by following a few steps.
How to Create Macros Stored in Excel?
To create a macro in Excel, open the workbook where you want to store the macro. Then, open the Visual Basic Editor by clicking the Developer tab on the ribbon and selecting “Visual Basic” from the Code group.
Once the Visual Basic Editor is open, click “Insert” on the menu and select “Module” from the list of options. This will create a new module in which you can type your macro code.
You’ll need to use the Visual Basic programming language to create the macro. If you’re unfamiliar with Visual Basic, don’t worry – it’s not too difficult to learn. Start by typing “Sub” followed by the name you want to give your macro.
You can write, copy/paste or edit on this VBP code window.
How to Use Macros Stored?
You first need to open the Microsoft Word program to use macros stored on your computer. Once Microsoft Word is open, click on the “Tools” menu and select “Macros.” A list of stored macros will appear in the window. To use a macro, click on the macro name and then click the “Run” button.
The Personal.xlsb file is a hidden file, so you may need to show hidden files and folders to be able to see it. This file stores the macro that you want to be available in all open workbooks. Macros stored in this file will automatically be available whenever you start Excel.