Personal.xlsb is a VBA macro file that opens when you open Excel and stores the "personal" macros you use. These macros will be accessible from any Excel file you open.
To create the file you need to: How to access a Macro in the Personal.xlsb file? Where is the Personal.xlsb file stored? Do a search on your system for the file. The code comes from your XLStart directory. You can also set the Excel Option > Advanced > General > At startup, open all files in: How do you open Excel without opening the start up macros? You should hold the shift key when opening Excel Prerequisites Other Sources |