Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

Web browsers, Help system, 792-794

Web pages, developers and, 14

Weekday function, 987

WeekdayName function, 987

welcome messages, 639

what-if models, 106

While Wend statement, 981

Width # statement, 981

WindowActivate event, 638, 656

WindowDeactivate event, 638, 656

WindowResize event, 638, 656

windows

activating, 977

docking, 157

hiding, 16

Windows API

default printer information, 379-380

directory, 311-312

directory selection, 404-406

disk drive information, 378

DLL (Dynamic Link Library) files, 311

file associations, 377-378

functions, 311-314

GetExecutable function, 377-378

MIDI files, 382-383

prompting for directories, 403

Registry, 384

Registry, reading from, 384-385

Registry, writing to, 385-386

ShellExecute function, 672-674

Shift key, 313

sound, playing from function, 383-384

video display information, 380-381

WAV files, 382

Windows, Macintosh and, 820-821

WinHelp, 794

With statement, 981

With-End With construct, 217-218

wizards

buttons , adding, 501-502

buttons, programming, 502-503

Finish button, 505-506

MultiPage control, 500-501

programming dependencies, 503-505

Word, controlling from Excel, 681-684

workbook events

Activate, 637, 640

AddinInstall, 637

AddinUninstall, 637

AfterXMLExport, 637

AfterXMLImport, 637

BeforeClose, 637, 643-645

BeforePrint, 637, 642-643

BeforeSave, 637, 640-641

BeforeXMLExport, 638

BeforeXMLImport, 638

Deactivate, 638, 641-642

description, 630

NewSheet, 638, 640

Open , 638, 639

PivotTableCloseConnection, 638

PivotTableOpenConnection, 638

RowsetComplete, 638

SheetActivate, 638, 640

SheetBeforeDoubleClick, 638

SheetBeforeRightClick, 638

SheetCalculate, 638

SheetChange, 638

SheetDeactivate, 638

SheetFollowHyperlink, 638

SheetPivotTableUpdate, 638

SheetSelectionChange, 638

Sync, 638

WindowActivate, 638

WindowDeactivate, 638

WindowResize, 638

workbook objects, 16

WorkbookActivate event, 656

Workbook_Activate procedure, 640

WorkbookAddInstall event, 656

WorkbookAddUninstall event, 657

WorkbookAfterXMLExport event, 657

WorkbookAfterXMLImport event, 657

WorkbookBeforeClose event, 657

Workbook_BeforeClose procedure, 644

WorkbookBeforePrint event, 657

WorkbookBeforeSave event, 657

Workbook_BeforeSave procedure, 641

WorkbookBeforeXMLExport event, 657

WorkbookBeforeXMLImport event, 657

WorkbookDeactivate event, 657

Workbook_Deactivate procedure, 641

WorkbookIsOpen function, 358

WorkbookNewSheet event, 657

Workbook_NewSheet procedure, 640

WorkbookOpen event, 657

Workbook_Open procedure, 639, 644

WorkbookPivotTableCloseConnection event, 657

WorkbookPivotTableOpenConnection event, 657

WorkbookRowSetComplete event, 657

workbooks

accessing add-ins as, 719

active, 16

add-ins, setup for, 705

closing, 344-345

creating add-ins from, 703-704

determining when opened, 658-659

document themes, 18

fonts, 934

introduction, 16

macro viruses, 939

opening, 639

procedures, listing all, 866

protecting, 123

read-only, 124

RibbonX code, 737-739

saving, 344

templates, creating, 84

Workbook_SheetActivate procedure, 640

WorkbookSync event, 657

worksheet events

Activate, 645

BeforeDoubleClick, 645, 652-653

BeforeRightClick, 645, 653-654

Calculate, 645

Change, 645-646

Deactivate, 645

description, 630

FollowHyperlink, 645

PivotTableUpdate, 645

SelectionChange, 645, 651-652

worksheet functions, add-ins, 105

Worksheet object

Cells property, 182-183

Range property, 181

worksheet sort , arrays, 352

Worksheet_BeforeDoubleClick procedure, 653

Worksheet_BeforeRightClick procedure, 653

Worksheet_Change procedure, 646

WorksheetFunction object, functions, 215

worksheets

activating, 639

activating, ListBoxes and, 476-479

active, 16

ActiveX controls, 118-120

built-in functions, 948

controls, using, 419-420

databases, 39-40

functions, 278

Help system, 784, 787-788

hiding, 123

introduction, 16

Loan Amortization Wizard and, 809-810

name , changing, 16

objects, locking, 123

Print Preview, 348-349

printed pages, number of, 348-349

scrolling, UserForms, 458-460

size , 17

synchronization, 346-347

Text Tools workbook, 537

XLAM files, 711

XLSM files, 711

zooming, UserForms, 458-460

Worksheet_SelectionChange procedure, 651

workspace files, 80

wrapper functions, 287

Write # statement, 844, 981

write position, text files, 985

WriteReadRange procedure, 336-337

writing to

ranges, 336-337, 337-339

text files, 843-844

Wrong number of arguments or invalid property assignment error, 992