P
Panes collection (Windows object), 151
Parameters
mandatory or optional, 130 ‚ 131
of methods , 128
passing by name , 131
Password, setting for an add-in, 300
Password exploit of Excel object model, 263
Password parameter (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
PlotBy parameter (ChartWizard method), 173 ‚ 174
PName class module, creating, 194 ‚ 198
Pop-up submenu
creating, 295 ‚ 299
removing, 298 ‚ 300
PrintOut method (Range object), 158
PrintOut method (Workbook object), 148
PrintOut method (Worksheet object), 154
PrintPreview method (Range object), 158
PrintPreview method (Workbook object), 148
PrintPreview method (Worksheet object), 154
Procedure argument data types, 31
Procedure stepping (debugging), 81
Procedures
executing at regular time intervals, 235 ‚ 236
viewing the statements that call, 81 ‚ 82
Project Explorer (VBA), 4 ‚ 7, 9
Project tree (Project Explorer), 4 ‚ 5, 9
Properties, 126 ‚ 133
dot notation for, 23
explained, 128
manipulating, 128 ‚ 130
read-only or read/write, 128
Property Let and Property Get statements, 194 ‚ 195
Protect method (Worksheet object), 154
ProtectContents property, 129