Save Custom Functions from Excel VBA in Add-in Files
A Macro to Unprotect a Worksheet on Workbook Open
Macro Security in Excel 2010

How to Edit Macros in Excel's Visual Basic Editor

Edit the statements in the Code window of the Visual Basic Editor as needed.

After you finish editing the macro, you’re ready to return to your spreadsheet, where you can test out the modified macro and make sure that you haven’t added some wacky, unwanted command to the macro or, even worse, crippled it so that it no longer runs at all.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Get VBA Code into a Module with Code Windows
3 Reasons to Use Macros for Your Excel Dashboards
A Macro to Protect Worksheets on Workbook Close
How to Customize the VBA Environment through the Editor Format Tab
An Overview of the Excel Object Model