Create or delete a macro - Office Support

You can use the macro recorder to record the macro or write your own macro script in VBA. ... When you select Personal Macro Workbook, Excel creates a hidden personal macro workbook (Personal.xlsb) if it does .... Applies To: Excel 2010.

support.office.com