From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Editing a macro - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Editing a macro
This workbook contains a macro that retrieves data from a separate file, copies it, and deposits it at the bottom of the current file. It just runs as a one-shot deal. It doesn't make any decisions. It doesn't ask for any additional information. If you do the exercise in the movie on recording a macro, you already know what its procedure is. What we will do in this movie is we will add three lines of VBA code to the macro that will ask your name then enter it at the top of the worksheet, so that the next person who runs the macro will know who used it last. Before we run the macro there are a couple things we have to do. Over here, if you have this yellow bar that says Security Warning, that's just Excel's way of telling you that, hey, there are macros in here that could be dangerous. Do you really want to run them? So click Enable Content. If you have that yellow bar and you don't enable content, you can't use the macros. Second thing we need to do is we need to open up the workbook…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.