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 |