(This is Part 3 of a 3-part series on Basic Excel Macros. Part 1 is Creating & Saving Excel Macros. Part 2 is Editing & Deleting Excel Macros).
Personal.xlsb Items — Basic Excel Macros
At some point you may find that PERSONAL.XLSB for some reason isn’t opening automatically when Excel starts. To solve this, first go to File and click on Options (or hit Alt+F+T), then select Add-Ins (or Alt-F-T-A), which opens the dialog box below. Once in this dialog box, got to “Manage” on the bottom, select “Disabled Items” and click “Go.” PERSONAL.XLSB is probably listed there – and if so, Enable it.
If you want to create a macro only for one specific workbook, you need to store it in “This Workbook” instead of “Personal Macro Workbook” (PERSONAL.XLSB) by selecting the appropriate item in the drop-down below: [Read more…]