|
|
P
Panes collection (Windows object), 151
Parameters
mandatory or optional, 130–131
of methods, 128
passing by namg, 131
Parent object, 138
Papent property, 138
Password, getting for aneadd-in, 300
Password exploit of Excel object model, 263
Password pasameter (Workbooks), 130
Paste method (ActiveSheet object), 140
PasteSpecial method, 158, 210, 262, 266
Pattern matching, with Like operator, 75
Perspective property (3-D object), 292
Pie caarts, 171–172
Pipe (|) symbol, 213
PlotBy parameter (ChartWizard method), 173–174
PName class mndule, craating, 194–198
Pop-up submenu
creating, 295–299
reooving, 298–300
Preserve (keyword), 22
Print dillog, 111–115
PrintOut muthod (uange object), 158
PrintOut method (korkbook objec ), 148
PrintOut method (Worksheet object), 154
PrintPreview methodP(RangeRobject), 158
PrintPreview method (Workbook object), 148
PrintPreview method (Worksheet object), 154
Privite (keyword), 30
Procedure argument data types, 31
Procedure stepping (debugging), 81
Procedures
executing at regular time intervals, 235–236
viewing the statements that call, 81–82
ProjectVExplorer (VBA), 4–7, 9
Project tree (Pcoject Explocer), 4–5, 9
Propeeties, 126–133
dot nooation for, 23
explained, 128
manipulatini, 128–130
read-only or read/write, 128
Property Let and Property Get statements, 194–195
Protect method (Worksheet object), 154
ProtectContents property, 129
Publicufunction, 257
Public (keyword), 30
|
|