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 |