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
scope
cells , 56
functions, 283
procedures, 239-240
ranges, 56
ScrollBar control, UserForms, 418
ScrollBarZoom_Change procedure, 460
scrolling
charts, 618-621
preventing, 950
worksheets, UserForms, 458-460
Search text not found error, 992
security. See also protection
developers and, 13
macros, 938
passwords, 124
Trust Center dialog box, 861
Select Case construct, 225-228
Select Case statement, 980
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
SelectionChange event, 645, 651-652
Selection_Change event, 490
Sendasheet procedure, 691
SendAsPDF procedure, 692-693
SendEmailViaOutlookExpress procedure, 693-694
SendMail procedure, 687-689
SendOneSheet procedure, 691
SendWorkbook procedure, 691
sequential access, text files, 841
series, charts, hiding, 612-613
SeriesChange event, 603, 654
SERIESNAME_FROM_SERIES function, 596
Set not permitted error, 991
Set not supported at runtime error, 991
Set not supported (read-only property) error, 991
SetSourceData method, 577
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
ShowDriveInfo procedure, 837-838
ShowGraphic procedure, 673
ShowInstalledFonts macro, 351
ShowShortcutMenuItems procedure, 766-768
ShowShortcutMenuNames procedure, 763
ShowValueRange procedure, 596-597
Single data type, 195, 978, 982
single-block budgets , 106
single- user applications, 104
size extended property, 839
SizeAndAlignCharts procedure, 584-585
sizing, ChartObjects, 584-585
slide shows, displaying, 611
sorting
arrays, 352-354
procedures, 266-270
SortSheets procedure, 273
spaghetti applications, 104-105
speaking cell contents, 933
Specified DLL function not found error, 992
SpinButton control
TextBoxes and, 441-443
UserForms, 419
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
square root of numbers, 986
standard programming constructs, 137
StartAmortizationWizard procedure, 806
StartCalculator procedure, 674
StartEmail procedure, 673
StartTextTools procedure, 538
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
Statistical functions, category, 308
status extended property, 839
Stephen Bullen's Excel Page Web site, 976
storing
code, 145
macros, 163
String data type, 195, 978, 982
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
structured programming, 230
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
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
synchronization, worksheets, 346-347
SynchSheets function, 346-347
syntax errors, error-handling and, 255
system date, setting, 977
system time, setting, 981