Search for courses or lessons
Redeem a coupon
Start free trial
Where are the commands needed to record and play macros located?
On the Developer tab
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
If you begin recording a macro, and you make a mistake:
You need to stop recording the macro, and try it again.
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.
Which types of scenarios are best suited to recording a macro?
Scenarios where the steps are repeated frequently, and are exactly the same every time the macro runs.
Scenarios where changes in data affect the outcome of the way 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
© 2020 GoSkills Ltd.
Skills for career advancement