Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

13. Automating Repetitive Tasks with Macros > Creating and Modifying Macros

Creating and Modifying Macros

The first step of creating a macro is to plan the process you want to automate. Computers today are quite fast, so adding an extra step that doesn’t affect the outcome of a process doesn’t slow you down noticeably, but leaving out a step means you will need to rerecord your macro. After you plan your process, you can create a macro by clicking the View tab and then, in the Macros group, clicking the Macros button down arrow. From the list that appears, click Record Macro. When you do, the Record Macro dialog box appears.

Creating and Modifying Macros

After you type the name of your macro in the Macro Name box, click OK. You can now perform the actions you want Excel 2007 to repeat later; when you’re done, click the View tab and then, in the Macros group, click the Macros button down arrow. From the list that appears, click Stop Recording to add your macro to the list of macros available in your workbook.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint