Wiley Excel 2007 All-In-One Desk Reference For Dummies 978-0-470-03738-6 ユーザーズマニュアル
製品コード
978-0-470-03738-6
Chapter 1: Building and
Running Macros
Running Macros
In This Chapter
⻬
Understanding how macros do what they do
⻬
Recording macros for instant playback
⻬
Using the relative option when recording macros
⻬
Running the macros you’ve recorded
⻬
Changing the macro security settings
⻬
Assigning macros to the Quick Access toolbar
M
acros enable you to automate almost any task that you can undertake
in Excel 2007. By using Excel’s macro recorder to record tasks that
in Excel 2007. By using Excel’s macro recorder to record tasks that
you perform routinely, you not only speed up the procedure considerably
(because Excel can play back your keystrokes and mouse actions much
faster than you can perform them manually), but you are also assured that
each step in the task is carried out the same way each and every time you
perform the task.
(because Excel can play back your keystrokes and mouse actions much
faster than you can perform them manually), but you are also assured that
each step in the task is carried out the same way each and every time you
perform the task.
Excel’s macro recorder records all the commands and keystrokes that you
make in a language called Visual Basic for Applications (VBA), which is a
special version of the BASIC programming language developed and refined
by the good folks at Microsoft for use with all their Office application pro-
grams. You can then use Excel’s Visual Basic Editor to display and make
changes to the macro’s VBA code.
make in a language called Visual Basic for Applications (VBA), which is a
special version of the BASIC programming language developed and refined
by the good folks at Microsoft for use with all their Office application pro-
grams. You can then use Excel’s Visual Basic Editor to display and make
changes to the macro’s VBA code.
In this chapter, you find out how to use Excel’s macro recorder to record,
test, and play back macros that you use to automate repetitive tasks required
when building and using your Excel worksheets and charts. In the next
chapter, you find out how to use Excel’s Visual Basic Editor to debug and
edit the macros that you record, as well as to create complex macros that
run custom functions and set up and run custom Excel applications, com-
plete with their own pull-down menus and dialog boxes.
test, and play back macros that you use to automate repetitive tasks required
when building and using your Excel worksheets and charts. In the next
chapter, you find out how to use Excel’s Visual Basic Editor to debug and
edit the macros that you record, as well as to create complex macros that
run custom functions and set up and run custom Excel applications, com-
plete with their own pull-down menus and dialog boxes.
36_037385 bk08ch01.qxp 11/17/06 11:08 AM Page 701
COPYRIGHTED MATERIAL