M

macro-enabled file formats, 11

macros

adding to Quick Access Toolbar, 772–773, 1120–1121

commenting out error handlers in, 1125

compiling project, 1122

conditional statements to end, 1119–1120

configuring in databases for untrusted locations, 780

digitally signing projects with, 55–56

Do vs. For…Next loops for, 1108–1110

errors

common, 1122–1123

handling, 1118, 1124–1126

help for, 1127

indenting code in VBA, 1112–1113

input boxes in VBA, 1117

length of names, 1084

loops in VBA, 1106–1111

passwords for VBA, 1128

recording in VBA, 1077–1079

running from another, 1118–1119

saving and sharing, 1127–1128

security

against viruses in, 661

digital signatures, 49

protection against malicious, 776–777

setting options for, 54–55

setting toggle commands in VBA, 1102

statements and procedures in, 1082

subroutines beginning and ending, 1080, 1086–1087

testing and debugging VBA, 1123–1124

Trust Center settings for, 47

variables

sharing through project, 1095

using in, 1091–1092

writing vs. recording, 1081–1082, 1085

mail clients

S/MIME-capable, 719

using other, 662

Make Office Better check box (Privacy Options dialog box), 761–762

Manage Alerts tab (Rules And Alerts dialog box), 744

Manager role (Groove), 140, 141, 173

manual page breaks, 216

manual recalculations, 428–429

many-to-many relationships, 881, 886

MAPI (Messaging Application Programming Interface), 643, 655

margins

adjusting border, 290–291, 292

aligning content vertically between, 222–223

balloon, 308

mirror, 222

specifying gutter, 211

Margins gallery, 209, 210

Margins tab (Page Setup dialog box), 220

Mark As Final command, 613

marking messages and contacts. See flagging messages

markup

displaying document, 60

tools for document, 302–304

MATCH function, 449–451, 480–481

Math & Trig button, 462

.mdb files, 861

MDI (multiple-document interface)

using in Access, 825–828

using in Excel, 380

Meeting Assistant, 635

Meeting Wizard, 156

Meetings tool, 155–157

illustrated, 155

linking action items to Calendar tool in, 157

setting up meetings with, 156

Memo data type

about, 858, 859

unavailable in Group, Sort, And Total pane, 1025

memo fields, 901

menus

Circular References, 431

File replaced by Microsoft Office Button, 8, 34, 35

Find & Select, 347

Item drop-down, 732, 733

locations on Ribbon for PowerPoint, 521–523

note tags, 103

Office, 8–9

Outlook startup from Start, 663

replaced by Ribbon, 27

Reviewers, 331

shortcut, 27, 38, 363, 364

alert, 186

using, 27, 38

worksheet, 363, 364

Site Actions, 84

smart tag action, 362

Sort By submenu, 818

Subdatasheet, 944

Text Fill, 552

View By submenu, 818–819

merging tracked changes, 60

Message Bar

configuring Access, 780

security alerts in, 49

Security Warnings in, 777

message boxes

creating line breaks and space between lines, 1133

deleting rows, 952

paste operation, 952

sharing information in VBA, 1114–1116

verifying SharePoint site is trusted, 737

Message History dialog box, 184–185

Message Security Properties dialog box, 706, 712, 713

Message tab (Outlook), 29

messages.

See also digital signatures; e-mail; error messages; messaging

communication status, 178, 179

convert to SmartArt, 554

digitally signing, 661–662, 689–690

faster method for, 703

outgoing mail, 698–699

encrypting, 662, 714–719

external content

accessing, 686, 687

blocking, 686–689

filtering by color category, 683–684

flagging

about, 678–679

changing flag status, 683

indicating received and sent mail, 678–680

marking contacts for follow-up, 681–683

with to-do item, 680–681

Groove message history, 184–185

HTTP-based e-mail, 642

invalid certificates for, 705

managing in Outlook mailboxes, 684

protecting with IRM, 721–722

reading

digitally signed, 704–705

encrypted, 718

received

adding notes to, 679

flagging, 678–680

saving in search folders, 675

sending

clear-text, 700

encrypted, 718

to Groove contacts, 137–138

sorting in folder, 683

suppressing Groove message alerts, 138

to-do items for outgoing messages, 680–681

viewing IRM-protected, 723–724

voice, 637

messaging, 641–644.

See also messaging protocols

extensible e-mail support in Outlook, 643

faxing, 643

instant, 182–184

integrating Outlook with Exchange Server, 641

Internet e-mail, 641

unified mode for, 662

Messaging Application Programming Interface (MAPI), 643, 655

messaging protocols, 654–659

defined, 654

HTML, 657–658

IMAP, 654–655

LDAP, 656

MAPI, 655

MHTML, 659

MIME, 658

NNTP, 656–657

S/MIME, 659

SMTP/POP3 protocol, 654

methods

about VBA, 1087–1088

object model member arguments, 1097–1098

object-oriented systems and, 970

SaveAs, Add, and HomeKey, 1097

unable to find VBA object, 1102–1103

MHTML (MIME HTML), 659

Microsoft Access. See Access

Microsoft Developer Network (MSDN) Library, 1115, 1141

Microsoft Excel. See Excel

Microsoft Exchange Server. See Exchange Server

Microsoft Office

activating, 1195

applications in, 16

automating, 1141–1142

changing setup for, 1195–1199

collaboration in, 5, 77–79

data input in, 28

diagrams from Office 2003, 581

finding Office commands, 23

galleries and Live Preview, 9–10, 25

installing from CD, 1191–1195

new features

Access, 15–16

Excel, 13

Outlook, 14–15

PowerPoint, 13–14

Word, 11–13

Office Online, 17–19

online Help, 41–43

privacy statement for, 61

removing from computer, 1196–1197

security options in 2003 vs. 2007, 54–55

user interface

applications using new, 22

dialog boxes in, 41

Office 2003 vs. 2007, 27

Quick Access Toolbar, 8

reasons for changing, 21

Ribbon, 6–9

using Clipboard in Access, 951

VBA with, 1075–1076

versions supporting IRM, 66

viewing ZIP packages in, 1150

XML

application prefixes for, 1145

file formats in, 10–11

Open XML Formats, 1190

Microsoft Office Button

Access features using, 766, 767–769

creating workspace through, 83

effect of startFromScratch command on, 1178

entering Options dialog box from, 34–35

File menu replaced by, 8, 34, 35

illustrated, 23, 24, 342, 767

Microsoft Office Communicator, 183

Microsoft Office Compatibility Pack, 599

Microsoft Office Diagnostics, 59, 1198–1199

Microsoft Office Forms Server, 16

Microsoft Office Genuine Advantage confirmation dialog box, 845, 846

Microsoft Office Groove. See Groove

Microsoft Office Groove Server, 16, 131

Microsoft Office InfoPath, 16, 22

Microsoft Office Live, 79

Microsoft Office OneNote. See OneNote

Microsoft Office Online, 17–19

Microsoft Office PowerPoint Compatibility Checker dialog box, 599, 600–601

Microsoft Office Project Server, 17, 22

Microsoft Office Publisher, 16

Microsoft Office Security Options dialog box, 49, 441, 778

Microsoft Office Trusted Location dialog box, 53, 607, 782

Microsoft Office Ultimate 2007, 79

Microsoft Office Visio, 16, 22

Microsoft Outlook. See Outlook

Microsoft Outlook Express, 719

Microsoft Passport

obtaining IRM certificate for, 721–722

required for IRM, 721

sending or viewing IRM-protected messages with, 720

working with multiple Passport accounts, 724

Microsoft PowerPoint. See PowerPoint

Microsoft Project, 59

Microsoft Save As PDF or XPS add-in, 531

Microsoft SQL Server, 859

Microsoft Update, 53

Microsoft Visual Basic for Applications. See Visual Basic for Applications (VBA)

Microsoft Visual Studio, 1147

Microsoft Windows 2000 Server, 657

Microsoft Windows Server 2003, 657, 720

Microsoft Windows XP

Outlook shortcut options in, 669

setting up file-sharing workspace in, 169

Microsoft Word. See Word

MID function, 470

.midi file format, 573

MIME HTML (MHTML), 659

MIME (Multipurpose Internet Mail Extensions), 658

Mini toolbar

about, 38–39

PowerPoint, 549, 554

minimizing Ribbon, 31, 787

minus (−) sign

arithmetic expressions with, 921

operator precedence of, 393, 923

starting formula with, 353

mixed references

changing reference to, 396

defined, 395

mobile devices, 115

MOD function, 463

Mod operator

operator precedence of, 923

using in arithmetic expressions, 921

Modify Button dialog box, 773

Modify Field dialog box, 196, 197

Modify Tab dialog box, 105

modules

creating, 1086–1087

exporting and importing, 1127–1128

VBA, 1082

More Options button (Permission dialog box), 67, 68

More Tools dialog box, 151

mouse

adding command to Quick Access Toolbar with, 776

dragging and dropping objects into custom groups, 808

dragging Microsoft Outlook icon to Quick Launch bar, 666

editing cells with, 361

making noncontiguous selections with, 345–346

moving between Excel regions, 342

selecting Excel data with, 344–347

using wheel to zoom, 371

movies

compatibility of QuickTime with PowerPoint, 575, 605

playing in full-screen mode, 575–576

using in presentations, 574–576

moving

between linked text boxes, 271–272

linked text boxes, 272–273

notebook content to other Office applications, 109

notebook sections, 97

between notebook sections, 94

outline topics, 249–251

SmartArt shapes, 572–573

worksheets, 365–366

.mp3 file format, 573

.mpeg file format, 575

MROUND function, 465

MSDN (Microsoft Developer Network) Library, 1115, 1141

MsgBox command, 1114–1116

multimedia formats in PowerPoint, 605

multiple Excel workbooks, 379–385

multiple reverse order sorts, 959

multiple-document interface (MDI), 380, 825–828

multiple-field indexes, 890–891

multiple-monitor support for Presenter view, 620

Multipurpose Internet Mail Extensions (MIME), 658

multithreaded calculations, 429

My Alerts On This Site page, 728, 729

My Documents folder, 607

 My tab.docx sample file, 1178

myInt variable, 1092