Microsoft Office Tutorials and References
In Depth Information
Alternatively, you can do the following:
1. Choose Tools
2. Choose a macro in the list of macros shown in the Macros dialog box,
as shown in Figure 17-6.
3. Click Run.
Figure 17-6:
The Macros
dialog box
lists all
macros in
any open
To edit a macro, you might want to simply re-record it, which is sometimes
the quickest way to do it. If you prefer to edit it instead, do the following:
1. Choose Tools
2. In the Macros dialog box that appears, choose the macro that you
want to modify and then click Edit.
The Microsoft Visual Basic editor opens; your macro is displayed in
Visual Basic code, as shown in Figure 17-7. Visual Basic code uses
certain syntax to code keystrokes and text entry.
To edit the code:
You can edit this code much as you edit text in a word
processorgenerated document. Although you have to be familiar with the
Visual Basic programming language to make most changes, you can
make some edits without being a programmer. For example, any
items in quotes are text entries or names of things, such as reports.
For example, it’s pretty easy to change a macro that generates the
report named “Tasks Starting Soon” so that it generates the
report “Tasks in Progress”. Just replace the existing report
name (within the quotation marks) with the new report name.
Search JabSto ::

Custom Search