P


Paste Special dialog box, 24

PasteSpecial method, 27

Pattern property, 179

payments, calculating for loan. see loan payment calculator

PivotCache object, 156

PivotTable reports

columns, autofitting, 166

columns, coloring, 168

columns, standardizing width, 163–164

creating, from external sources, 156–158

creating, from internal sources, 153–156

data fields, referencing, 161

data fields, renaming, 158–159

dates, formatting, 159

defined, 153

headers, turning off, 164

items with no data, displaying, 162–163

layout, customizing, 162–167

memory caches, connecting to

same, 155

memory caches, loading for, 155

structuring, 158–162

styles, copying, 168

styles, customizing, 167–169

text fields, moving outside Row Labels

area, 159

practice files on CD, xv–xvi

browsing to, xix

installing, xviii–xix

uninstalling, xx

printing reports, 329–331

private procedures, 250

procedures

vs. macros, 250, 267

private, 250

Project Explorer window, 76

properties

actions and, 72

changing, 83

changing multiple at once, 13–18

defined, 11, 69

deleting unnecessary inserted by

macro recorder, 17–18

displaying all for object. see Auto List

Members

Help topics for, displaying, 177

vs. methods, 25, 27, 28, 72

vs. methods, in recorded macros, 72

object for, recognizing, 17

objects returned by, finding, 183

read-only, 78, 83

read-write, 83

referencing multiple, 17

state, viewing current, 20

syntax in macros, 17, 18

toggling values of, 20–21

unsupported, 11

Properties button, 265

Properties window, 76

Protect method, 299

protecting worksheets, 297, 299–300

public variables, 278

publishers, setting yourself as, 31–34



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