V

validating

digital signatures, 711–714

template authenticity, 845, 846

validation rules

comparison symbols and characters in, 869–870

enforcing for subdatasheets, 879

errors if validation text missing, 865

field

defining, 868–870, 877

properties for, 863

testing changes to, 937–938

table

checking new, 938–940

setting up, 875–878

Value Field Settings dialog box, 506, 507

variables, 1091–1098

calling macro from other to define, 1119

data types for VBA, 1092–1093

declaring, 1093–1094

defined, 1091

document, 1096–1097

naming, 1092

sharing through project, 1095

using as text strings, 1093

workarounds when type doesn’t work, 1096

VBA. See Visual Basic for Applications (VBA)

VBE. See Visual Basic Editor (VBE)

vCalendar protocol, 659

vCard protocol, 659

Verify Identity dialog box, 193

VeriSign, 48, 690, 691, 717

version control

document, 732–735

enabling Version History, 734

shared document check in, 732–734

versions

file types for PowerPoint, 529

IRM support in Office, 66

opening and saving earlier file format, 11

PowerPoint 2007 compatibility with earlier, 530, 599–602

upgrading from previous Office, 1192

Versions Saved page, 734, 735

video

recording in OneNote, 109–111

searching OneNote, 119

View By submenu (Access), 818–819

View Certificate dialog box, 706–707, 713

View Ruler command, 220

View Side By Side button, 383

viewing

all file extensions, 1149

contents of Clipboard, 250

digital fingerprint, 190

digital signatures, 711–714

documents

in Outline view, 239–241

in split windows, 247, 248

Groove workspaces, 150

libraries or lists using Excel queries, 82

messages protected with IRM, 723–724

multiple calendars, 635–636

only active workbook windows, 386

relative number of current record, 940

rights-managed content, 69

shared contacts, 735–737

version history of Word documents, 338

worksheets, 366–372

creating custom views, 372

freezing panes, 368–370

split into panes, 367–368

zooming, 370–371

views. See also specific application views

Access object, 790–795

designing form, 200–202

display options for tracking changes, 323–324

Final Showing Markup, 326

headers and footers visible in, 223

PowerPoint, 533–535

viruses

scanning, 660

security against macro, 661

Visio, 16, 22

Visual Basic for Applications, (VBA).

See also Visual Basic Editor (VBE)

about, 1076

ActiveX control settings for, 57

applying Word Theme fonts and colors, 1105

arguments, 1098–1099

code

coding document-level events, 1132

efficiency in, 1095

indenting, 1112–1113

preceding comment lines with apostrophe, 1080

reading, 1079–1080

compiling projects, 1122

conditional structures in, 1111–1112

constants, 1099–1101

data types for variables, 1092–1093

errors

error handlers, 1118, 1124–1126

getting help for, 1127

returned for some properties, 1090

trapping individual, 1126

events in, 1131–1133

grouping statements, 1103–1104

input boxes in, 1117

loops in, 1106–1111

macros

common errors for, 1122–1123

conditional statements to end, 1119–1120

recording macros, 1077–1079

running, 1120–1121

saving and sharing, 1127–1128

setting toggle commands in, 1102

starting one from another, 1118–1119

testing and debugging, 1123–1124

writing vs. recording, 1081–1082, 1085

message boxes, 1114–1116

methods, 1087–1088

names in, 1084

object models, 1088–1089

member arguments, 1097–1098

objects

about, 1087–1088

collection, 1101–1102

selecting, 1130

unable to find properties or methods, 1102–1103

operators, 1113–1114

properties, 1087–1088, 1102–1103

reasons to use, 1076

statements, procedures, modules, and projects in, 1082

UserForms

automating, 1138–1140

designing, 1134–1138

using Visual Basic Editor, 1082–1085

variables, 1091–1098

Visual Basic Editor (VBE)

Auto Lists in, 1090–1091

Code window in, 363, 1083

constant sets needed in, 1100–1101

creating modules and starting procedures, 1086–1087

declaring variables automatically, 1094

digitally signing macro projects, 56

illustrated, 1083

Immediate window, 1121, 1129–1131

Object Browser, 1088–1089

Project Explorer, 1083–1084

Properties window, 1084–1085

selecting database template options, 898

using, 1082–1085

viewing VBA macro code in, 1079–1080

workspace options for, 1085

Visual Studio, 1147

VLOOKUP function

comparison values and vertical tables, 477

example of, 478

vector form of LOOKUP function, 476–477

voice comments, 302, 314