Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
Save Custom Functions from Excel VBA in Add-in Files
How to Add Dialog Boxes to Excel Macros with Visual Basic Editor
Where Is the Visual Basic Editor in Excel 2013?

How to Edit Macros in Excel's Visual Basic Editor

Step 5 of 5
Next Slideshow
Next Slideshow

Click the Save button on the Quick Access toolbar to save the changes to the modified macro if it’s stored as part of the current workbook.

If you modified a global macro saved as part of the Personal Macro Workbook, you have to exit Excel in order to save your changes to the macro. When you click the Excel program window’s Close button or press Alt+FX or Alt+F4, Excel displays an alert dialog box asking whether you want to save the changes you made to the personal.xlsb file.

Click the Yes button to save your macro modifications as you close down Excel.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
Excel VBA Programming For Dummies Cheat Sheet
How to Find Form Controls for Excel Dashboards and Reports
3 Reasons to Use Macros for Your Excel Dashboards
How to Find and Replace Code in a Visual Basic Editor Macro
Use the Combo Box Control for Your Excel Dashboards
Advertisement

Inside Dummies.com