7.

S

Saved property, 62

SchemeColor property

vs. ColorIndex property, 106

Fill object, 106

ScrollBar object

adding to worksheets, 215

event handler for, 222

LargeChange property, 215

LinkedCell property, 222

Max property, 215

SmallChange property, 215

searching for properties values in Object Browser, 102-3

security, digital signatures

SelectChart macro

editing, 80-84

writing, 80

Select Data Source dialog box, 259

SelectionChange event

at workbook level, 204-5

at worksheet level, 202-4

Selection object

vs. ActiveCell object, 117

Copy method, 17

NumberFormat property, 9

PasteSpecial method, 17

Selection property, 98

Select method

placement in macros, 73

Worksheets object, 65-66

Select Objects button, 279

Select…Selection statement pairs, 116-17

SelectShapes macro, 73-76

Select statements, 117

selfcert program, 20

self-signed certificates, 19-21

SelLength property, 249

SelStart property, 249

SetBars macro, 290-91

SetFocus method, 249

SetMenu macro, 285-86

SetPivot macro, 273-74

SetWindow macro, 287-89

Shape object

BackColor property, 73

vs. ChartObject object, 82

Fill property, 87

ForeColor property, 73

overview, 76

RGB property, 83

vs. ShapeRange object, 74-75

in Shapes collection, 84

subobjects, 73

ShapeRange collection, 76

ShapeRange object, 76

shapes

adding to worksheets, 70-73

vs. drawing objects, 87

modifying on worksheets, 73-76

overview, 76-77

renaming, 77

selecting on worksheets, 76

Shapes collection, 84

Shapes property, 74

sheets. See worksheets

shortcut keys, assigning to macros, accelerator keys

ShowDetail property, 132

ShowForm macro, 250

ShowView macro, 242-43

signatures. See digital signatures

SmallChange property, 215

Solid method, 75

SourceName property, 133

spelling errors, 170

SpinButton object

adding to worksheets, 212-14

event handler for, 222

LinkedCell property, 222

Max property, 214

SmallChange property, 214

starting Microsoft Excel, 3

StartOfMonth function, 249

StartUpAnimation macro, 282-84

statements, VBA

breaking into lines, 30

ConvertToValues macro, 16-18

eliminating when unnecessary, 12-13

FormatCurrency macro, 8-9

interpreting, 9

overview, 8

static variables, 290

StatusBar property, 159

stepping through macros, 29-32

Stop Recording button, 70

Style property

ComboBox object, 217-18

CommandBar object, 251

subcollections, 65-66

subordinate macros, 47-49

subroutines, 48-49

summary fields, 134

Summary view, creating, 240-42

suppressing event handlers, 205-7

SynchronizeCharts macro, 86-87

syntax errors, 170