Creating Macros in Microsoft Excel

1
Creating Macros in Microsoft Excel
2
In order to unlock Microsoft Excels most
powerful features, users need to use Visual Basic
for Applications. This may seem daunting at first
for most users, but it is surprisingly easy to
use some of its features by simply recording
macros and adding a few buttons.

3
This tutorial will take you through the basic
steps needed to get started with macros. However,
in order to put the use of macros in context, we
will begin by creating a Quiz in Microsoft Excel,
and subsequently we will record a macro, assign
it to a button, edit it, and finally we will look
at our security settings.

4
Please select one of the tutorials below to
proceed

• creating a quiz
• recording a macro and button
• editing a macro
• changing security settings

view
view
view
view
Once you have finished with the tutorials, you
can proceed to the next slide to view the
finished quiz.
5
By selecting the link below, you can view the
finished quiz. Feel free to explore how it was
put together, and to modify it for your needs
(you will need to unprotect the sheet first, and
there is no password assigned to it). Also, make
sure that your Excel security settings are set so
as to allow the execution of macros.
view finished quiz
x
6
(No Transcript)
7
(No Transcript)