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