How Do I View And Edit A Macro In Excel?

How do I open Macro Editor in Excel?

Click the View Macros option on the Macros command button on the View tab or press Alt+WMV or Alt+F8. This action opens the Macro dialog box showing all the names of the macros that you’ve defined in the workbook and in your Personal Macro Workbook.

How do I edit a macro in Excel 2013?

1:31

9:41

Suggested clip 78 seconds

Microsoft Excel 2013 Essentials Editing Macros in Visual Basic for

YouTube

Start of suggested clip

End of suggested clip

Why can’t I edit macro in Excel?

Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen. choose “View Macros” and then select the “Edit” button it doesn’t open for editing. Instead, it appears to run the macro.