S

/s switch, 75

SaveAllGraphics procedure, 586-587

SaveAllWorkbooks function, 344

SaveChartAsGIF procedure, 585

SaveDefaults procedure, 812

SaveSetting statement, 980

saving

charts as GIF files, 525

files, date, 363-364

workbooks, 344

SayIt function, 363

scope

cells , 56

functions, 283

procedures, 239-240

ranges, 56

Scroll event, 661

ScrollBar control, UserForms, 418

ScrollBarZoom_Change procedure, 460

scrolling

charts, 618-621

preventing, 950

worksheets, UserForms, 458-460

Search text not found error, 992

Second function, 985

security. See also protection

developers and, 13

macros, 938

passwords, 124

Trust Center dialog box, 861

Seek function, 986

Seek statement, 980

Select Case construct, 225-228

Select Case statement, 980

Select event, 603, 654

SelectAllButton_Click procedure, 475

SelectByValue function, 341

SelectCurrentRegion macro, 320

selected cells, counting, 326-327

selected ranges, looping, 329-332

selecting

cells by value, 340-342

color , in UserForms, 523-524

directories, Windows API and, 404-406

objects, 32-33

ranges in UserForms, 452-453

rows, ListBoxes and, 474-476

Selection property, 178

SelectionChange event, 645, 651-652

Selection_Change event, 490

Sendasheet procedure, 691

SendAsPDF procedure, 692-693

SendEmailViaOutlookExpress procedure, 693-694

SendKeys method, 693-695

SendKeys statement, 981

SendMail method, 690

SendMail procedure, 687-689

SendOneSheet procedure, 691

SendWorkbook procedure, 691

sequential access, text files, 841

series, charts, hiding, 612-613

SERIES formula, 592-593

SeriesChange event, 603, 654

SERIESNAME_FROM_SERIES function, 596

server application, 677

Set not permitted error, 991

Set not supported at runtime error, 991

Set not supported (read-only property) error, 991

Set statement, 981

SetAlarm procedure, 662

SetAttr command, 830

SetAttr statement, 981

SetElement method, 589

SetSourceData method, 577

Sgn function, 986

shadows, charts, 590-591

Shape object, ChartObject, 575

shapes

color, background, 917-919

fills, 919-925

introduction, 38-39

MakeShapeWithGradient procedure, 920

MakeShapeWithPattern procedure, 921

MakeShapeWithPicture procedure, 922

MakeShapeWithText procedure, 924

MakeShapeWithTexture procedure, 923-924

UserForms, 961

SheetActivate event, 638, 640, 656

SheetBeforeDoubleClick event, 638, 656

SheetBeforeRightClick event, 638, 656

SheetCalculate event, 638, 656

SheetChange event, 638, 656

SheetDeactivate event, 638, 656

SheetExists function, 358

SheetFollowHyperlink event, 638, 656

SheetOffset function, 372

SheetPivotTableUpdate event, 638, 656

SheetSelectionChange event, 638, 656

Shell function, 670-672, 986

ShellExecute Windows API function, 672-674

shortcut keys

creating, 116-117

macros, 163

shortcut menus

adding automatically, 775-776

Cell , new item, 770-772

context-sensitive, creating, 777-779

context-sensitivity, 26

customizing, 26, 116

deleting automatically, 775-776

developers and, 13

disabling, 769

disabling items, 770, 776-777

hiding items, 776-777

icons, 773-774

items, displaying all, 766-768

listing, 762-763

resetting, 768-769

right-clicking, 26

setup, 639

submenus, adding, 772-775

Show method, UserForm object, 427

ShowCaption procedure, 764

ShowChart procedure, 600-601

ShowChartAsGrayScale procedure, 908

ShowComponents procedure, 864-865

ShowDataForm method, 411

ShowDriveInfo procedure, 837-838

ShowGraphic procedure, 673

ShowInstalledFonts macro, 351

ShowShortcutMenuItems procedure, 766-768

ShowShortcutMenuNames procedure, 763

ShowValueRange procedure, 596-597

sign of number, 986

Sin function, 986

sine of numbers , 986

Single data type, 195, 978, 982

single-block budgets , 106

single- user applications, 104

size extended property, 839

Size setting (VBE), 156

SizeAndAlignCharts procedure, 584-585

sizing, ChartObjects, 584-585

slide shows, displaying, 611

SLN function, 986

Smart Tags, 28

SmartArt, 38-39

Solver, 42

sorting

arrays, 352-354

procedures, 266-270

SortSheets procedure, 273

SortTester routine, 267

sounds, 963, 977

Space function, 986

spaghetti applications, 104-105

spaghetti code, 229

Spc function, 986

speaking cell contents, 933

SpecialCells method, 258

Specified DLL function not found error, 992

speed of system, 129

SpinButton control

TextBoxes and, 441-443

UserForms, 419

spinners, Ribbon, 22-23

splash screen, creating, 454-455

Split function, 370-371, 986

spreadsheet applications. See applications

spreadsheets

for-your-eyes-only, 104

Lotus 1-2-3, 5-6

Quattro Pro, 7

quick-and-dirty, 103

VisiCalc, 4

Sqr function, 986

square root of numbers, 986

standard programming constructs, 137

StartAmortizationWizard procedure, 806

StartCalc procedure, 670

StartCalculator procedure, 674

StartEmail procedure, 673

StartTextTools procedure, 538

startup actions, 74

StartWord procedure, 675

statements

AppActivate, 977

Beep, 977

Call, 977

ChDir, 977

ChDrive, 977

Close, 977

Const, 977

Date, 977

Declare, 978

DefBool, 978

DefByte, 978

DefCur, 978

DefDate, 978

DefDbl, 978

DefDec, 978

DefInt, 978

DefLng, 978

DefObj, 978

DefSng, 978

DefStr, 978

DefVar, 978

DeleteSetting, 978

Dim, 978

Do-Loop, 978

For Each-Next, 979

End, 978

Enum, 979

Erase, 979

Error, 979

On Error, 980

Event, 979

Exit Do, 979

Exit For, 979

Exit Function, 979

Exit Property, 979

Exit Sub, 979

FileCopy, 979

For-Next, 979

Function, 979

Get, 979

GoSub Return, 979

GoTo, 979

If-Then-Else, 979

Implements, 979

Input, 844

Input #, 844, 979

Kill, 979

Let, 979

Line Input #, 844, 979

Load, 979

Lock Unlock, 979

Lset, 979

Mid, 979

MkDir, 979

Name , 980

On GoSub, 980

On GoTo, 980

Open, 842, 980

Option Base, 980

Option Compare, 980

Option Explicit, 980

Option Private, 980

Print #, 844, 980

Private, 980

processing conditionally, 980

Property Get, 980

Property Let, 980

Property Set, 980

Public, 980

Put, 980

RaiseEvent, 980

Randomize, 980

ReDim, 980

Rem, 980

Reset, 980

Resume, 980

RmDir, 980

RSet, 980

SaveSetting, 980

Seek, 980

Select Case, 980

SendKeys, 981

Set, 981

SetAttr, 981

Static, 981

Stop, 981

Sub, 981

Time, 981

Type, 981

Unload, 981

While Wend, 981

Width #, 981

With, 981

Write #, 844, 981

StatFunction, 371-372

Static statement, 981

static variables , 202

Statistical functions, category, 308

status bar, hiding, 932

status extended property, 839

Stephen Bullen's Excel Page Web site, 976

Stop statement, 981

storing

code, 145

macros, 163

Str function, 986

StrComp function, 986

StrConv function, 986

String data type, 195, 978, 982

String function, 986

string representation of number, 986

strings

alignment, 980

characters , replacing, 979

comparing, 980

converted, 986

converting character code to, 982

converting to lowercase, 984

converting to time serial number, 986

converting to uppercase, 987

fixed-length, 205

leading spaces, 985

number of characters in, 984-985

operating environment, 983

positing in string, 984

repeating, 986

reversed , 986

variable-length, 205

StrReverse function, 986

structured programming, 230

stylistic formatting, 34

Sub or Function not defined error, 990

Sub procedures

Ctrl+shortcut key, 242-243

declaring, 238-239

Function procedures and, 276

introduction, 190

Macro dialog box, 241-242

Ribbon and, 243

Run Sub/UserForm command, 241

sub procedures, 145

Sub statement, 981

subject extended property, 839

submenus, adding to shortcut menus, 772-775

Subscript out of range error, 949, 989

subtypes , variables, 987

SUM function, emulating, 301-304

SumArray function, 294

summing formulas, 66

Switch function, 986

SYD function, 986

Sync event, 638

synchronization, worksheets, 346-347

SynchSheets function, 346-347

syntax errors, error-handling and, 255

system date, setting, 977

system requirements, 993

system speed, 129

system time, setting, 981