(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: [Read more…]