56.

W

Watch window, 57

windows

dockable, 57-62

dockable vs. child, 57

resizing, 287-89

With structure, 118

wizards

Chart Wizard, 268-70

Data Connection Wizard, 259-61

PivotTable and PivotChart Wizard, 262

PivotTable wizard, 124

Text Import wizard, 27-28

WordArt

adding state codes to map, 275

Alignment button, 280

changing object shape, 280-81

vs. command buttons, 275-78

creating logos, 279-81

formatting text, 277

SameLetterHeights button, 280

Shape button, 280

Workbook object vs. Workbooks object, 59

Workbook_Open event handler, 291

workbooks

adding worksheets, 62-63

changing available palette colors, 107

closing, 58-59

closing singly, 59-60

counting, 57-58

creating, 55-56

deleting worksheets, 174-75

and digital signatures, 22

dragging worksheets to, 28

handling events, 204-5

listing methods and properties, 66-67

moving worksheets to, 28

as objects, 52

opening, 3

opening with blank sheet, 291

overview, 55-67

role of worksheets, 52

viewing Enterprise Information System, 256-58

Workbooks object

Add method, 58

Close method, 58-59

Count property, 61-62

Item property, 63

OpenText method, 32

referencing by name, 60-61

referencing by pointing to, 61

significance in Excel, 59-60

vs. Workbook object, 59

vs. Workbooks property, 60

Workbooks property vs. Workbooks object, 60

Worksheet object

and PivotTables, 123

vs. Worksheets object, 92

worksheets

adding command buttons, 192-95

adding to workbooks, 62-63

appending to databases, 40-46

associated event handler procedures, 201-2

as collections, 52

comparing ranges via CompareCells macro, 150-52

copying, 65

creating custom views, 240-42

creating maps, 274-75

creating via Add method, 64-65

currency format, 4-6

deleting from workbooks, 174-75

deleting rows, 29

dragging to new workbooks, 28

handling events, 202-4

merging cells vertically, 9-12

moving to new workbooks, 28

multiple, 92

as objects, 63

overview, 62-67

protecting, 290

ProtectSheets macro, 152-53

removing gridlines, 13-15

renaming, 63

role in workbooks, 52

role of cells in, 52

Worksheets collection, 92

Worksheets object

Activate method, 66

Add method, 64-65

Copy method, 65

Name property, 63

Select method, 65-66

vs. Worksheet object, 92



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net