S

Sandbox, 14 Save As command (File menu), 499

Save as Web Page command

(File menu), 341 SaveAs() function, 366 SaveChart() function, 202 scatter charts, 196, 203

ScheduleAnything()

function, 339 ScheduleTheDay() function, 337

scheduling macros canceling previously scheduled macros, 338-339 CaptureData() function, 337

DebtClock case study,

340-341 OnTime() function, 337 Ready mode, 337-338 running every two minutes,

339-340 running x minutes in the future, 339

ScheduleTheDay()

function, 337 windows of time for updates, 338

Schemas (XML), 351-352 ScrollBar1_Change() function, 446

scrollbars, 446-447 secondary axes, 190-191

SecondaryAxisDemo()

function, 191 security add-ins, 502 digital signatures, 19 macros, 14-15

Security command (Macro menu), 14 Select() event, 155

Select...Case statement, 101-102 SelectAHO function, 434

selecting cells non-contiguous cells,

311-313 SpecialCells() function, 71-73, 324-325 ranges

Cells property, 64-65 CurrentRegion property, 70-71

non-contiguous ranges, 74

Selection objects (Word), 367

SelectionChange() event, 152

SelectSentence() function, 369

Send to Back command

(UserForm toolbar), 433 separating delimited strings, 94-95 worksheets into workbooks, 299-300

Series object, 188-189 SeriesChange() event, 156, 202

SeriesCollection collection, 188

SeriesDemo() function, 189

SetReportInItalics() function, 476-477 SetSourceData() function, 179

SetTimer API function, 460 SetValuestoTabStrip() function, 437

SheetActivate() event, 147,

0 0

Post a comment