Rock your resolutions. Take the Dummies challenge and you could WIN $1,000! Get Started.
Save Custom Functions from Excel VBA in Add-in Files
3 Reasons to Use Macros for Your Excel Dashboards
Excel Dashboards and Reports: How to Run Your Macros

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.

blog comments powered by Disqus
Excel Dashboards: How to Record Your First Macro
Use the Check Box Control for Your Excel Dashboards
Macro Security and Authenticode in Excel 2013
Enable and Trust Macros for Your Excel Dashboards and Reports
How to Assign Macros to the Ribbon and the Quick Access Toolbar in Excel 2013
Advertisement

Inside Dummies.com