As a macro is being executed, you have the option to evaluate each line of code one at a time.
- On the ribbon, click Manage tab
Applications panel
Run VBA Macro.
- In the Macros dialog box, Macros In drop-down list, select the project file you want to work with.
- In the Macros list, select a macro and click Step Into.
On the Debug toolbar or Debug menu, click Step Into to continue the execution of the macro one line at a time. Click Continue to resume normal execution of the macro.