62.

M

macro languages, VBA)

Macro Options dialog box, 6-7

macro recorder, as reference tool, 69-71

macros. See also event handlers; macros (by name)

ActiveX controls and, 279

adding statements, 44

for adjusting PivotCharts, 272-74

animation in, 281-84

assigning shortcut keys to, 11

breaking statements into lines, 30

for charts, 78-87

for complicated projects, 26-49

creating, 4-9

custom functions in, 169-70

deleting, 44

editing after recording, 85

eliminating unnecessary lines, 12-13

enabling via digital signature, 19-22

enhancing recorded selections, 116-18

event handlers and, 279

interpreting, 9

launching with events, 183-207

linking command buttons to, 196-97

in modules, 11

naming, 5

organism analogy, 163

recording actions, 70-71

recording to change property values, 5-6

renaming, 15

running, 6

running subroutines, 47-49

saving changes, 45-46

setting breakpoints, 157-58

stepping through, 156-57

subordinate, 47-49

testing, 29-32

variables in, 33

viewing, 7-9

watching run, 29-32

writing, 71-73

macros (by name). See also event handlers; macros

AddDates, 38-40

AppendDatabase, 40-43

ChangeChart, 84-85

CheckFiles, 178-81

CheckRun, 147-48

CompareCells, 150-52

ConvertToValues, 16-18

DeleteSheet, 174-75

FillLabels, 36-37

FormatCurrency, 5-6

HideMonths, 243-46

ImportFile, 27-29

LabelMonths, 116-17

ListFiles, 153-55

MakeAnalysis, 175

MakeBoldItalic, 117-18

MakeChart, 78-79

MakeNewRectangle, 71-73

MakeNextReport, 175-78

MakePivot, 124-26

MakeRectangle, 70-71

MakeReport, 171-78

MakeTotals, 114

MergeVertically, 10-13

MonthlyProject, 47-49

MoveRight, 142-44

NameState, 275-78

PrintOrders, 155-60

ProtectSheets, 152-53

RemoveGrid, 13-14

SelectChart, 80

SetMenu, 285-86

SetPivot, 273-74

SetWindow, 287-89

ShowView, 242-43

StartUpAnimation, 282-84

SynchronizeCharts, 86-87

TestInput, 144-46

TestRange, 98-99

ToggleGrid, 15

UnprotectSheets, 150

ZoomIn, 184-92

ZoomOut, 184-92

MakeAnalysis macro, 175

MakeBoldItalic macro, 117-18

MakeChart macro, 78-79

MakeNewRectangle macro, 71-73

MakeNextReport macro, 175-78

MakePivot macro

in its entirety, 138-39

saving Immediate window explorations, 137

steps in creating, 124-26

MakeRectangle macro, 70-71

MakeReport macro, 171-78

MakeTotals macro, 114

maps

adding state codes, 275-78

creating on worksheets, 274-75

Max property, 215

members. See methods; properties

menu bars

customizing, 284-86

naming, 284

replacing, 284-86

restoring, 286

menus

adding ZoomIn macro, 189-90

adding ZoomOut macro, 189-90

creating, 188-89

removing, 191-92

Merge And Center button, 9

MergeCells property, 12

MergeVertically macro

creating, 10-11

MergeCells property, 12

naming, 11

Orientation property, 12

viewing, 11-12

methods

for collections, 54

global, 96

listing in Immediate window, 56

and object classes, 53

overview, 53-54

vs. properties, 54

viewing in Object Browser, 90

Microsoft Excel

importing text files into, 27-28

opening files, 3

role of object library, 2-3

role of Visual Basic for Applications, 51

starting, 3

toolbars, 4-5

Microsoft Office selfcert program, 20

modal forms, 251

Module1 module, 200

modules, 200

MonthlyProject macro, 47-49

MouseMove event, 198-99

MoveRight macro, 142-44

MsgBox function, 179

multiple worksheets, 65-66