Task 6: Create Macros

Help my Macros don't work anymore!

Go to the Office button > Excel Options > trust center > Macro Settings
Select Enable all macros > Click OK > Click OK
Save and close your spreadsheet
Open your spreadsheet up again,
Click on Enable Macros
your macros should work again now.

Pass

Record a Macro to automate at least one task

A1 - Record a simple Macro to automate at least one task

(Go to tools and record macro).

A2 - Assign a keyboard shortcut to your Macro

A3 - Print out the Macro code

Tools > Macros > Play Macros - click on edit Macro - Print

Merit

B1 - Record a Macro to automate a sequence of a least two tasks

B2 - Assign a keyboard shortcut to your Macro

B3 - Assign a button to your Macro

B4 - Print out the Macro code

B5 - Describe what the Macro does and how it can be run

Distinction

C1 - Record a new Macro that automates a sequence of at least two tasks

C2 - Assign a keyboard shortcut to your Macro

C3 - Assign a button to your Macro

C4 - Print out the Macro code

C5 - Annotate the Macro code to describe what at least three parts of the code do