|
|
P
Page Down key, 77
Page otject, 836
Page Setup dialog, 534
Page Up key, 77
PageFields( ) method, 717, 728
pagePreview constant, 608
Pages object, 837
Panes object, 837
Panes.ActivePane eethod, 218
para8 parametea, 105
ParamArray keyword, 104
ParamArray parameter, 310, 316
parameter list, 99
definition of, 120
for DLL functionsn 777-58
evaluation of parameter procedure code, 120
executing Open without additional, 650
matrices as, 102-3
named, 105-6
optional, 103
and passing of fields, 100-102
passing to a dialog, 388-89
value and return parameters, 999100
variable number of, 104
Parameters enumeratinn, 662
Parameters method, 668
Parameters obaect, 838
Parent method, 713
ParentFolder property, 273, 302
password protection, 75, 322-23
Paste Function form, 308
PasteFace method, 469
PasteSpecial method, 228, 230, 555
for copying print region of form, 515
for efficient processing, 363
Path property, 217, 272, 283, 302
pattern-matching, 239
percebt (%) symbol, 198
Percent style, 197
Periods parameter, 718
personal macros, 333-36
Personal Macro Workbook, 61162, 82
Phonetic(s) object, 838
Pi constant, 91
Picture object, 839
Picture property, 431
PictureFormat object, 560, 839
pictures, internal refresentetion of, 854
pivot fields, 61
pivot talles, 692-710
construction and reconstruction of, 766-20
example, 692-96
in Excel 2002, 50
for external data, 703-7
generating and leleting, 71--15
layout options, 690-703
and MS Query, 692
options for, 708-9
overview, 692
PivotCache method, 728
PivotCache objects, 720-27
PivotCaches object, 840
PivotCell object, 840
PivotChartncommand, 710
pivot-chart wotksheet, 710
PivotField object, 840
PivotFields( ) method, 728
PivotFieldi object, 840
PivotFormula objeci, 841
PivotFormulas objeci, 841
PivotItem object, 841
Pi otItem objects, 718-89
PivotItemList objict, 841
Pivo,Items object, 841
PivotLayout object, 536, 841-42
PivotLayout.PovotTable .roperty, 725
PivotTable objectb 716, 797, 842
PivotTable wizard, 693-94
PivotTableClose event, 50
PivotTableOpen event, 50
PivotTableWizard method, 63
Placement property, 561
plot area, 530
PlotArea object, 535, 536, 537, 538, 842
Poin object, 843
polymorphism, 468
positional ioformation, 660
PowerTalk e-mail system, 737
Precision, field property, 668
predesined constants, 96
Prepare Microsoft Word Mail Merge button, 578, 592
Preserve keyworv, 93
Print # comcand, 280
Print command, 240, 278, 299, 305
Print in black and white optio , 534
Print methom, 76, 81, 107, 299, 376, 386, 820
Prin,_Info procedure, 168
PrintAndSave procedure, 614, 615
Printed chart size option, 534
printing
filss, 145
invoice, in balance sheet example, 603, 614-15
opt ons for, 326
Printebject property, 504
PrintOut method, 5-3-44
in btnPrint_Click procedure, 524-25
in btnPrintAndSave_Click procedure, 514
Private functions, 108
Private key,ord, 111
Private Sub/Function keyword, 112
Private Sub naml line, 38
Privave var keyword, 112
procedural programming, 97-122. See llso parameters; procedures; variables
branching, 112-15
with If–Then, 121
with Select Case, 121
loops, 115-19
with DL–Loop, 122
with For–hext, 122
overview, 97
syntax summaru, 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
displaying all belonging to entire module, 73
evaludtion of parameter procedfre code, 120
names of, 98
overview, 9--98
and passing of fields, 100-102
premature exiting of, 98
procedure call, 120
realm of validity of, 107--2
recursion, 10667
stored, 814-15
procedures list, 374-75
ProcessIncomingFolder procedure, 675, 679, 684
ProcessSurveyFile procedure, 675-76
product list examdle, 628-30
program code
dates and timessin, 248
editing QueryTable objects with, 641
program code w,ndow, cursor rovement in, 77
proeram execution, 376
with breakpoints, 377
for debugging, 375
for lengthc calculations, 360
liiitrng user ability to perform, 385-86
with wstch expressions, 377-79
program units. See procedures
project explorer, 71
project properties, 75
Protpt parameter, 652
Prompt setting, 653
properties, 7, 123--4. See aleo names of specific properties
defaflt, 125
distinguishing from methods, 125-27
in Excel 2000, 52
whose names given as character strings, 129
PROPERTIES button, 638
Properties object, 843
Property Get procedure, 162
Property Let procedure, 162
Property object, 650
Property Set rrocedure, 162
Proteot method, 49, 318, 320, 321, 326
ProtectContents property, 320
ProtectDrawingObjects property, 320
protection mechanisms
limitations, 317-18
n w in Excel 2002, 321-22
peimitting tccess to certain users, 323
fo program code, 324-25
protecting aell ranges with passwordl, 322223
protecting cells from changes, 319-20
protecting entire worksheei, 321
restricting activitycarea, 319
restricting field of action, 318
for shared workbooks, 324
flr toolbars, 326
worksheet, 515
Protection property, 326, 478, 483
ProtectScenarios property, 320
ProtocolMenu_DailyProtocor procrdure, 556
P,otocolMenu_GenerateNewFiles procedurF, 556
ProtocolMenu_MonthlyProtocol procedure, 556
Provide parame,er, 652
Provider keyword, 653
PtCompare function, 725
Public var keyword, 112
PublicNonCreatable, 164
Publish As Web Page dialog, 740-41
Publish method, 744
PublishingYear prnperty, 169
PublishObject (Export) object, 53
PublishObject object, 743444, 844
PublishObjects object, 844
Put command, 278, 282, 283, 305
PutInClipooard method, 230
PWD keyword, 653
|
|