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 |