This Microsoft Office RECORDING MACROS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
| 1) | Download the files needed to start this exercise: exercise-240.zip (and click here if you experience any problems unzipping this file after downloading it). | ||
| 2) | Macros have been recorded and assigned to buttons that allow you to change various aspects of the picture. Record a macro to change the colour of the socks to blue. Assign this macro to a new button. | ||
The first step of your macro might be to select the appropriate range from the Name Box
|
|||
| 3) | Record macros and assign them to buttons to create your perfect kit. | ||
| 4) | If you are ambitious you might want to try creating a stripy kit. | ||
|
|||
| 5) | Save this file as My Perfect Kit.xls | ||
Thank you for showing an interest in this Advanced Excel training course!
Recommended sites: C# corner | Computer tutorials | Training classes