12.

P

packaging applications, 284-91

page breaks, assigning via PrintOrders macro, 156-58

page fields, 134

PageRange property, 135

palettes, color, 107

Paste Special dialog box, 115-16

PasteSpecial method, 17

period (.), in macro statements, 56

personal signature. See digital signatures

PivotCache collection, 291

PivotCache object, 125

PivotCharts

changing colors, 271

creating from PivotTables, 268-70

formatting, 270-71

macro for adjusting, 272-74

making transparent, 270-71

moving to worksheets, 269

positioning, 269

PivotField object, 135

PivotFields collection, 130

PivotItem object

Name property, 133

overview, 130

Position property, 133

ShowDetail property, 133

SourceName property, 133

Visible property, 133

pivot items. See PivotItem object

PivotTable and PivotChart Wizard, 262

PivotTables

adding columns, 266

adding fields, 262

changing background, 267

changing label formatting, 267

copying for PivotCharts, 268

creating, 124-26

creating via Data Connection Wizard, 259-62

database connection, 263

defining, 262-64

enabling selections, 267

enhancing report layout, 264-71

finding ranges, 135-37

formatting, 266-68

grouping data, 265-66

manipulating pivot fields, 130-32

in Object Browser, 123-24

overview, 122-24

PivotField object, 123

refining, 130-38

setting Table Options, 263

sorting data, 264-65

PivotTable wizard, 124

points, 72

Position property

PivotField object, 130

PivotItem object, 133

PrintOrders macro, 155-60

print preview mode, 249-50

procedures, defined, macros

Project Explorer, 247

projects, VBA

adding digital signatures, 21

storing procedures, 200-202

prompts, hiding, 47

properties

vs. arguments, 18

changing, 9-13

for collections, 53

creating, 206-7

custom, 206-7

global, 96-97

listing in Immediate window, 56

vs. methods, 54

object classes and, 53

overview, 52-53

searching for values in Object Browser, 102-3

viewing in Object Browser, 90-91

Properties button, 193

protecting

user interface only, 223

worksheets, 290

ProtectSheet macro, 289

ProtectSheets macro

For Each structure in, 149-50

For loop in, 152-53

overview, 149