Personal.xlsb is a special Excel Workbook whose macros are available to all opened Excel workbooks. Personal.xlsb as the Personal macro workbook when asked if modification to it should be changed. Personal.xlsb seems to be %appdata%\Microsoft\Excel\XLSTART. This directory can be determined in VBA with application.startupPath. Personal.xlsb has been created, it will automatically be opened (and visible) whenever Excel is started. Personal.xlsb can be made invisible when Excel is started by using the View -> Window -> Hide menu. Personal.xlsb, it should be made visible again. Personal.xlsb can be hidden like so: workbooks("Personal.xlsb").windows(1).visible = false