| < Day Day Up > |
|
Wait method, 117, 128
warning box, during validation, 188
Watch window, 45
Web
currency quotes on, 94
Excel color palette on, 226-29
publishing worksheets to, 523-25
Web Components
adding interactivity with, 534-35
in Office 2003, 11
Web Options dialog box, 522
Web pages
adding interactivity on, 526
containing frames, 528
naming, 521
opening as workbooks, 528
opening in Excel, 528
parsing, 532
posting on the Internet, 523-25
presenting results as, 533-37
publishing to behave like spreadsheets, 11
saving help and informational files as, 146
saving worksheets as, 520-23, 534
specifying titles for, 522
Web Queries, 529-31, 532
Web server. See also server
communicating with, 536-37
posting new results directory to, 534
sending information to, 536
setting up, 533
Web Servers Home Directory, 533
Web sites, 525, 531
Web-based worksheets, 525-27
WebTables property, 531
Weekday function, 214
Weight argument of BorderAround method, 237
Weight property of Borders object, 236
Where clause
comparison operators in, 473
in Select statement, 473
in Update statement, 479
white space
determining for a worksheet, 154
stripping from a string, 196
white VBA color constant, 219
width of a cell, 174
Width property
of ChartObject object, 337
of Column object, 172
of CommandBar object, 368
of CommandBarControl object, 375
of a user form, 398
of a user form control, 403
of UserForm object, 398
wildcard characters
used with the Access database, 474-75
using with SEARCH, 203
Window menu in Visual Basic Editor, 53
Window Settings options, 51
window state of an application, 446
windows. See also code windows
arranging all open when a workbook is deactivated, 271
controlling the zoom level of, 114
layout preventing users from changing, 143
moving, 49
moving to display a particular cell, 114
returning the currently selected, 113
returning to a docked position, 49
simultaneous scrolling of two, 7
specifying dockable, 52
undocking, 49
Windows authentication, 504
Windows Explorer, 53
Windows program controls, 19
Windows registry
manually changing, 250
verifying entries in, 256
Windows-based applications, starting from a DOS window, 446
wininet.dll file, wrapper for, 536
With...End With command, 73
WithEvents keyword, 278, 304, 310
WizardApp.xls, 432
wizards
building multi-step, 431-41
collecting options for, 438-40
navigating pages in, 435-37
running, 441
summarizing options in, 440
Word application, late binding with, 450
Word documents, 457-59, 460-62
WordWrap property, 405
Workbook event procedures, 268
Workbook events, 265, 267-73
Workbook object, 107
calling the Save method, 135
contained in an Application object, 326
creating, 456
events attached to, 268
events for, 267
as the parent of the Charts collection, 326
returned by ActiveWorkbook, 115
as the top-level object, 457
workbook window
controls, 19
scrolling through, 276
Workbook_Activate event, 246
Workbook_AddinInstall event, 245
Workbook_AddinUninstall event, 245
Workbook_BeforeClose event, 434, 500
Workbook_BeforeSave procedure, 271
Workbook_Close event, 246
Workbook_Deactivate event, 246
Workbook_Open event, 246, 269
in Application object, 277
in Excel Query program, 499
in ThisWorkbook module, 433
Workbook_Open event procedure, 268, 269, 272, 279
WorkbookOpen function, 279
workbooks, 13, 129
activating, 137, 145
adding sheets to the end of, 151
adding XML to manually, 550-53
building new quarterly, 115
changing every open, 129
changing the active, 137
changing the position of sheets in, 153
checking for write-protected, 142
checking to see if open, 134
closing, 138
comparing side by side, 7
copying color palettes from, 225
creating, 129, 151, 241-43
detecting when opened, 279
digitally signing, 39
displaying in Print Preview mode, 148
displaying macros in, 31
forcing to recalculate, 120
of macro currently running, 119
making backup copies of, 137
maximizing, 270
maximum number of colors, 14
methods, 145-47
modifying all charts in, 338
opening, 130-35
opening Web pages as, 528
printing and previewing, 147-48
properties of, 138-44
protecting from changes, 142-43
providing hot keys specific to, 126
recalculating, 119, 120, 272
referencing the currently selected, 115
removing protection from, 144
requiring passwords to open, 141-42, 157
saving, 135-37, 138, 141, 242
selecting a range of cells from, 415
signing VBA code associated with, 39
write-protected, 142
Workbooks collection, 129-48
worksheet elements
assigning colors to, 223
formatting, 230-31
Worksheet events, 265, 273-76
worksheet functions, 197
Worksheet object
contained in Workbook object, 326
containing a PivotTable, 348
events for, 273
Worksheet_Change procedure, 230
calling itself repeatedly, 266
executing, 275
monitoring the Change event, 267
WorksheetFunction object
calling the PMT function, 209
calling the SEARCH and FIND functions, 204
calling worksheet functions as properties of, 197
need for, 196
worksheets, 13, 14
alternative data sets for, 15
centering vertically on the printed page, 154
changing the name of, 149
changing the tabs of, 230
code ensuring an empty, 357
colors in, 219-31
compared to tables, 467
computing the previous row in, 425
creating with new PivotTables, 357-58
data limits of, 14
dealing with two-dimensional data, 341
entering information into, 419-31
event triggered when right- clicking, 274
forcing to print on a specified number of pages, 155
methods, 156-60
navigating among, 14
navigating event procedures in, 274
number of default, 13
printing on a specified number of pages, 154
proving two at a time, 159
publishing to the Web, 523-25
recalculating all formulas in, 156
reducing read and writes to, 185
reformatting the elements of, 219-37
removing unused from a workbook, 116
retrieving currently selected, 112
right-clicking, 276
saving as Web pages, 520-23, 534
selecting, 160
shrinking for printing, 154
typing data into, 187
Worksheets collection, 149-50, 151
Write# statements, 296
write-only property, 304
write-protected workbooks, 142
WriteReserved property, 142
write-reserved workbook, 130
WriteResPassword parameter, 130, 136
| < Day Day Up > |
|