If you’re able to find the file click on Macros Button on the Developer Tab and click on the drop down near macros in. From there, you would find Personal Macro Workbook, select Personal Macro Workbook and list of macros saved should appear in the list. For any other concerns, don’t hesitate to get back to us.
It should open every time you start Excel, so if it is not doing this then perhaps it has become disabled? From within Excel, go Help>About Microsoft Excel>Disabled Items and re-enable it if it is listed here.
How do I save a macro in Excel?
After you’ve created your macro, you’ll want to save it so you can use it again in the current workbook or in other workbooks. Save a macro with the current workbook If you’ll need the macro only in the workbook where you created it, click Saveor Save Aslike you normally would.
Another frequent query is “How do I make macros available in excel every time?”.
To make your macros available every time you open Excel, create them in a workbook called Personal., and xlsb. That’s a hidden workbook stored on your computer, which opens every time you start Excel. See Create and save all your macros in a single workbook to learn how to do this.
Where to find the personal macro workbook in Excel?
Now, whenever you get the Excel file, you just need to run the macro (which is stored in the personal workbook and can be accessed from any workbook), and you’re done. By default, the personal macro workbook doesn’t exist. You need to first create it.
That’s a hidden workbook stored on your computer, which opens in the background every time you open Excel. Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab.