Alternatively, you can always easily edit VBA code of your personal workbook macros using the Visual Basic Editor (VBE) environment. Navigate to the View tab, click on Unhide dialog box, and then select your PERSONAL.XLSB file and click OK to view it. To edit existing macro in your personal workbook, you would need to first unhide your personal workbook. Should you want to use a shortcut to save you a step, ALT + F8 would do the trick. To run your macro, you can either navigate to the View tab, or Developer tab and then click on Macros, all of the macros in the personal macro workbook would show under the Personal! location. To create another macro and save it in your personal macro workbook, follow the same steps and re-save your workbook. They type of action you actually record is not overly important, as you can easily edit your VBA code once your stop recording your macro and save changes to your personal workbook. The key is to ensure that you store your macro in Personal Macro Workbook location.
To record a macro, we simply need to navigate to the Excel ribbon and select the View tab, click on Macros and then Record Macro alternatively, you have your Developer tab enabled, you could invoke a Record Macro wizard from there. The easiest way to save your code into PERSONAL.XLSB workbook is through recording a macro. This productivity hack would help us perform repetitive tasks (formatting and data presentation pet peeves, anyone) by automating them. This is where the personal macro workbook comes into play: if we save our code in this centralized place, we could use it in any Excel workbook on our local drive. While the power of Excel VBA is limited only by our creative imagination, the real limitation of a typical VBA code comes from the fact that it resides in the workbook where it was saved, and as such, can only be revoked while this file is open. We have already explored different Excel VBA macros here, here, and here.