Back to lesson
1. Where are the commands needed to record and play macros located?
On the Excel status bar (located at the bottom of the Excel window)
On the Developer tab
In a hidden window that can only be accessed with a password
2. If you begin recording a macro, and you make a 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.
You need to click Undo to back up one step and remove the mistake.
3. 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
© 2017 GoSkills Ltd.
Skills for career advancement