Datasheet

5
Chapter 1: Using Macros and Form Controls
5
4
6
Because of problems with macro viruses, by default
Excel disables all macros when you open a workbook.
You can read the file, but you cannot execute the
macros. You can click Macro Security on the Developer
tab to change the default setting, or you can click the
Enable Content button that appears when you open the
workbook to enable the macros. To learn more about
macro security, see the sections “Set Macro Security,”
“Create a Digital Signature,” and “Assign a Digital
Signature to a Macro” in this chapter.
To save a workbook that has macros, click the File tab.
A menu appears. Click Save As. The Save As dialog box
appears. Locate the proper folder. Type a filename in
the File Name field. Select Excel Macro-Enabled
Workbook (*.xlsm) in the Save As Type field. Click
Save. Excel saves your workbook as a macro-enabled
workbook and gives the workbook an .xlsm extension.
•
The Developer tab appears on the Ribbon.
•
Click Record Macro to record a macro.
•
Click Use Relative References to record with a
relative reference.
•
Click Macro Security to change macro security.
The Customize the Ribbon pane appears.
4 Click the down arrow and then select Main Tabs.
5 Click Developer ( changes to ).
6 Click OK.
03_591598-ch01.indd 503_591598-ch01.indd 5 6/11/10 1:41 PM6/11/10 1:41 PM