Excel Macro Cara Edit Macro. In the macro name box click the macro that you want to edit. When you recorded the macro you selected a workbook to store the macro.
How to create and edit excel macros step 1. There are 65 years of data listed for 4. In the macros dialog box from the macros in drop down list select the project containing the macro you want to edit.
On the ribbon click the developer tab then click macros.
The visual basic editor appears. Once the file tab has been selected the window will appear as above now click on the options as shown in. Excel vba edit your recorded macro open the macro workbook. When you recorded the macro you selected a workbook to store the macro.
