Datasheet

Chapter 1: Using Macros and Form Controls
5
1
2
4
3
5
SAVE A WORKBOOK
1 Click the Microsoft Office button.
A menu appears.
2 Click Save As ➔ Excel Macro-Enabled
Workbook.
The Save As dialog box appears.
3 Click here and then select the folder in which
you want to save your workbook.
4 Type the name you want to give your
workbook.
5 Click Save.
Excel saves your workbook as a macro-enabled
workbook.
Because of problems with macro viruses, Excel
disables all macros by default when you open a
workbook. You can click the Macro Security button
on the Developer tab to change the default setting.
To learn more about macro security, see the
sections, “Set Macro Security,” “Create a Digital
Signature,” and “Assign a Digital Signature to a
Macro.”
If you have programming experience or aptitude,
you can edit Excel macros by using the Visual Basic
Editor, which is available by pressing the Visual
Basic button on the Developer tab.
You can use the Macro dialog box to run a macro.
To open the Macro dialog box, click the Macro
button on the Developer tab, press Alt+F8, or place
the View Macros button on the Quick Access
toolbar.
To place the View Macros button on the Quick
Access toolbar, click the Microsoft Office button,
and then click Excel Options. The Excel Options
dialog box appears. Click Customize. The Customize
the Quick Access Toolbar pane appears. In the
Choose Commands From field, choose Popular
Commands and then click View Macros. Click the
Add Button. Click OK. The View Macros button
appears on the Quick Access toolbar.
04_132302 ch01.qxp 7/27/07 9:19 PM Page 5