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