PageFields() method, 717, 728
pagePreview constant, 608
PageRange property, 716, 728
PageSetup object, 331, 837
Panes.ActivePane method, 218
ParamArray parameter, 310, 316
parameter list, 99
definition of, 120
for DLL functions, 757-58
Parameter object, 649, 838
parameters
evaluation of parameter procedure code, 120
executing Open without additional, 650
matrices as, 102-3
named, 105-6
optional, 103
parameter list, 99, 120
and passing of fields, 100-102
passing to a dialog, 388-89
value and return parameters, 99-100
variable number of, 104
Parameters enumeration, 662
ParentFolder property, 273, 302
Password parameter, 651, 652
password protection, 75, 322-23
Paste method, 202, 228, 229
PasteSpecial method, 228, 230, 555
for copying print region of form, 515
for efficient processing, 363
pasting cells , 202, 228-30
Path property, 217, 272, 283, 302
Personal Macro Workbook, 61-62, 82
Personal.xls file, 140, 224
PictureFormat object, 560, 839
pictures, internal representation of, 854
pivot charts , 52, 529, 709-10
pivot tables, 692-710
construction and reconstruction of, 716-20
example, 692-96
in Excel 2002, 50
for external data, 703-7
generating and deleting, 711-15
layout options, 697-703
and MS Query, 692
options for, 708-9
overview, 692
PivotCache object, 642, 839
PivotCache objects, 720-27
pivot-chart worksheet, 710
PivotFields() method, 728
PivotFormulas object, 841
PivotItem objects, 718-19
PivotItemList object, 841
PivotLayout object, 536, 841-42
PivotLayout.PivotTable property, 725
PivotTable object, 716, 797, 842
PivotTable wizard, 693-94
PivotTableClose event, 50
PivotTables object, 714, 842
PivotTableWizard method, 63
PlotArea object, 535, 536, 537, 538, 842
Position property, 467, 483
positional information, 660
PowerTalk e-mail system, 737
Precision, field property, 668
Prepare Microsoft Word Mail Merge button, 578, 592
Print command, 240, 278, 299, 305
Print in black and white option, 534
Print method, 76, 81, 107, 299, 376, 386, 820
Print_Info procedure, 168
PrintAndSave procedure, 614, 615
Printed chart size option, 534
printing
charts, 534, 543-44
files, 145
invoice, in balance sheet example, 603, 614-15
options for, 326
PrintObject property, 504
PrintOut method, 543-44
in btnPrint_Click procedure, 524-25
in btnPrintAndSave_Click procedure, 514
Private Sub/Function keyword, 112
Private Sub name line, 38
procedural programming, 97-122. See also parameters; procedures; variables
branching, 112-15
with IfThen, 121
with Select Case, 121
loops , 115-19
with DLLoop, 122
with ForNext, 122
overview, 97
syntax summary, 119-22
procedures, 97-107. See also names of specific procedures
call procedures, 105
calling, 104
creating with macro recorder, 513
data types of values returned by functions, 99
definition of, 77, 119, 121
displaying all belonging to entire module, 73
evaluation of parameter procedure code, 120
names of, 98
overview, 97-98
and passing of fields, 100-102
premature exiting of, 98
procedure call, 120
realm of validity of, 107-12
recursion, 106-7
stored, 814-15
ProcessIncomingFolder procedure, 675, 679, 684
ProcessSurveyFile procedure, 675-76
product list example, 628-30
program code
dates and times in, 248
editing QueryTable objects with, 641
program code window, cursor movement in, 77
program interruption
with breakpoints, 377
for debugging, 375
for lengthy calculations, 360
limiting user ability to perform, 385-86
with watch expressions, 377-79
program units. See procedures
properties, 7, 123-24. See also names of specific properties
default, 125
distinguishing from methods , 125-27
in Excel 97, 57
in Excel 2000, 52
Excel-specific, 283-86, 303
whose names given as character strings, 129
properties window, 34, 71-72
Property Get procedure, 162
Property Let procedure, 162
Property Set procedure, 162
Protect method, 49, 318, 320, 321, 326
ProtectContents property, 320
ProtectDrawingObjects property, 320
protection mechanisms
limitations, 317-18
new in Excel 2002, 321-22
permitting access to certain users, 323
for program code, 324-25
protecting cell ranges with passwords, 322-23
protecting cells from changes, 319-20
protecting entire worksheet, 321
restricting activity area, 319
restricting field of action, 318
for shared workbooks, 324
for toolbars , 326
worksheet, 515
Protection object, 49, 843
Protection property, 326, 478, 483
ProtectScenarios property, 320
ProtocolMenu_DailyProtocol procedure, 556
ProtocolMenu_GenerateNewFiles procedure, 556
ProtocolMenu_MonthlyProtocol procedure, 556
Provider parameter, 647, 651
Public keyword, 108, 110, 161
public variables, 108, 608
Publish As Web Page dialog, 740-41
PublishingYear property, 169
PublishObject (Export) object, 53
PublishObject object, 743-44, 844
PublishObjects object, 844
Put command, 278, 282, 283, 305
PutInClipboard method, 230