Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Basic Excel Macros: Part 2 Of 3, Editing & Deleting Excel Macros

October 18, 2016 by Terp Leave a Comment

(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:

unhide-personal-xlsb

Then make sure PERSONAL is selected in the window below, and hit OK:

unhide-personal-xlsb-2

Once you hit OK, you’ll be in the PERSONAL.XLSB workbook.

Then click on the Macros icon below:

view-macros

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):

excel-macro-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:

excel-macro-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:

edit-personal-xlsb

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).

save-excel-macro

 

Conclusion

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).

Filed Under: Excel Macros Tagged With: Excel macros

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel