Microsoft Office Tutorials and References
In Depth Information
Collaborating with the Review Tab
To view the VBA code that makes up a macro in Word, Excel, or PowerPoint,
follow these steps:
1. Click the View tab.
2. Click the Macros icon that appears in the far-right side of the Ribbon.
If a menu appears, click View Macros. The Macros dialog box appears.
3. Click the macro name that you want to examine and click the Edit
The Visual Basic for Applications window appears. In this window, you
can edit and create VBA code.
To take advantage of VBA programming, you’ll need to learn more about
the VBA language, such as from a book like VBA For Dummies, by John
Paul Mueller (Wiley).
4. Choose File
Close and Return.
Collaborating with the Review Tab
If you’re the only person who needs to edit, view, and use your Office 2010
documents, you can safely skip over this section. However, if you’re like
many people, you need to collaborate with others.
The old-fashioned way of collaborating meant printing paper copies, sending
them to others, and writing directly on them, but with Office, you can
highlight, mark up, and edit documents electronically so that you can distribute
files by e-mail or through a network. Each time someone makes a change to
a document, Office 2010 tracks these changes with a different color and even
identifies the contributor by name. Now you can see who wrote what, and
you can selectively keep those comments that are most valuable and ignore
the ones you don’t like.
Some of the more useful commands hidden on the Review tab include:
New Comment: Lets you insert a comment directly into a document
without affecting the existing text.
Track Changes: Highlights any new text or data that someone adds to an
existing document.
Compare: Examines two files and highlights the differences between
the two. This tool also gives you the option of selectively merging the
changes into a single document.
By using the features stored on the Review tab, you can send multiple copies of a
file to others, let everyone make comments, mark up the text, move data around,
and then merge everyone’s comments and changes into a single, final version.
Search JabSto ::

Custom Search