Search for courses or lessons
Redeem a coupon
Start free trial
Where are the commands needed to record and play macros located?
On the Excel status bar (located at the bottom of the Excel window)
In a hidden window that can only be accessed with a password
On the Developer tab
If you begin recording a macro, and you make a mistake:
You need to click Undo to back up one step and remove the mistake.
That mistake is recorded in the macro, and will be played back each time you run the macro.
You need to stop recording the macro, and try it again.
Which types of scenarios are best suited to recording a macro?
Scenarios where changes in data affect the outcome of the way the macro runs.
Scenarios where the steps are repeated frequently, and are exactly the same every time the macro runs.
Scenarios that are not repeated often, but where the steps are the same each time the macro runs.
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement