How Do You Suspend And Resume A Macro In Excel?
During playback of a previously recorded macro in Microsoft Excel 2007, you can suspend or resume the macro at any point. The macro will immediately suspend its actions and then will wait for you to tell it to resume. Start Microsoft Excel 2007, and open a workbook from your files that contains a macro you have already recorded and now would like to suspend and resume while the macro is running. Run the macro you want to suspend and resume while it is playing. You can do this by accessing the “Macro” dialog box or using the keyboard combination you set to run the macro when you created it. Press the “Esc” key on your keyboard to suspend the macro that is running. The macro will immediately stop when the button is pressed. Use the keyboard shortcut to run the macro or the “Macro” dialog box to resume the macro. The macro will start over again. Follow the same procedure to suspend and resume the same macro in a different spot during playback or to suspend and resume a different macro tha
