(This is Part 2 of a 3-part series on Basic Excel Macros. Part 1 is Creating & Saving Excel Macros. Part 3 will cove some issues with Personal.xlsb and how to add a macro to your Quick Access Toolbar.)
How To Edit & Delete Basic Excel Macros
If you want to edit or delete the macro, you first need to Unhide PERSONAL.XLSB by clicking on the item below in the View tab:
Then make sure PERSONAL is selected in the window below, and hit OK:
Once you hit OK, you’ll be in the PERSONAL.XLSB workbook.
Then click on the Macros icon below:
This will open up the following dialog box (or, to skip the Ribbon, you can us the Alt+F8 shortcut to jump right to this dialog box):
Here you can delete it by clicking on “Delete” on the right hand side.
If you want to change the macro’s name or shortcut key, click on Options:
But if you actually want to edit the macro, click on the Edit button – and you’ll get this scary window below (Visual Basic editor) which contains the actual VBA code if you want to edit this way:
Another way to edit it without knowing code (say you recorded it wrong the first time) is simply to delete the old one and then re-record.
Once you’re done, it’s best to “Hide” PERSONAL.XLSB again so you don’t mistake it for a blank file and start messing around with it.
When you exit an Excel session during which you created, edited or deleted a macro in PERSONAL.XLSB, you may get the following message – make sure you hit “Save” not “Don’t Save.” (And don’t forget to Hide PERSONAL.XLSB before saving).
You now know how to:
- create Excel macros (part 1);
- edit Excel macros (part 2 — this post); and
- delete Excel macros (part 3 — this post)
In the third and final post, I’ll cover some issues with Personal.xlsb, and show you how to add a macro to your Quick Access Toolbar (QAT).