W


Watch window, 76

window elements in worksheets, removing, 18–19

windows, rearranging, 15

With structures, 17

objects, consolidating with. see objects

replacing Select groups with, 116

Workbook object, 320

WorkbookConnection object, 157

workbooks

active, referencing, 82

architecture of, 67

closing, macro for, 78

closing without saving changes, 83

counting, macro for, 77–78

creating, 143, 144

creating, macro for, 73–75

digital signatures, adding, 32

event handlers for, 276–277

events available for, 276

file extensions, 12

macro-free vs. macro-enabled, 12

macros, enabling, 13

master list. see master lists

moving worksheets between, 140

referring to, 69, 81–82

saving, 21

specifying, in macros, 79–81

trusting macro-enabled, 28–35

viruses in. see viruses

windows for, 76

Workbooks object

Add method, 73

Close method, 78

Count property, 77–78

Saved property, 83

Worksheet object, 97

worksheets

activating from selection, 88

adding, macro for, 84

Auto List Members, activating, 89–90

blank cells, selecting, 48–49

code name, identifying, 183

colors in. see colors

columns. see columns, worksheet

constants, displaying only, 318

copying, macro for, 87

creating new files from, 138–140

current region. see current region

deleting, 61–62

deleting, macro for, 85

events available for, 275

formatting, clearing, 134

formulas, inserting in all selected cells, 49

moving to different workbooks, 140

name, displaying, 84

naming, macro for, 85

naming of identical copies, 41

protecting, 297, 299–300

referencing cells in, different in Excel 2007, 100

relative references vs. absolute

references, 58–60

rows, deleting, 41

selecting all cells on, 98, 101

selecting, macro for, 88

selecting multiple, 62

views. see views

window elements, removing with macro, 18–19

Zoom level, changing, 262–263

Worksheets object

Add method, 84

Name property, 85

vs. Worksheet object, 97



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

Similar book on Amazon
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Excel 2003 Formulas
Excel 2003 Formulas
Writing Excel Macros with VBA, 2nd Edition
Writing Excel Macros with VBA, 2nd Edition

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