This message will appear every time you create a new macro or update an existing macro in your personal workbook.ĭone! The Personal.xlsb file is created and will be automatically opened in the background every time you start Excel. Doing this display a message prompting you to save the changes you've made to the Personal Macro Workbook, and you click Save:
How to create Personal Macro Workbook in Excel Please follow the below steps to make one. If the XLSTART folder does not exist on your computer, that means your personal macro workbook is not created yet. So, to get to the XLSTART folder in Windows Explorer, check the Hidden items box on the View tab. Please note that the AppData folder is hidden by default. On Windows 10, Windows 7, and Windows Vista:Ĭ:\Users\User Name\AppData\Roaming\Microsoft\Excel\XLSTARTĬ:\Documents and Settings\User Name\Application Data\Microsoft\Excel\XLSTART\
The Personal.xlsb file is stored in the XLSTART folder in the following locations. Once the Personal.xlsb file is created, you can add any other macros to it by using the VB Editor. To create it, you will need to record at least one macro. Microsoft Excel just knows the location where this file lives in your system and looks for it automatically on every launch.Īside from macros, the Personal Macro Workbook can store your custom functions (user-defined functions) written in VBA.Ī fly in the ointment is that the Excel Personal Macro Workbook does not exist by default. A great thing about the personal workbook is that it's hidden by default, so you won't ever notice it opening in the backend. Any macros stored in this file are available to you whenever you start Excel. Personal Macro Workbook is a special file named Personal.xlsb in Excel 2007 – 2019 or Personal.xls in earlier versions.