How Do You Learn Macros In Excel 2007?
Excel macros are pieces of code that you can use to automate repetitive tasks and customize Excel 2007 to fit your needs. You don’t need to know a programming language to build a macro. Excel’s Record Macro function will record your keystrokes and generate code in the background. When you want to execute the code, you can press a keyboard combination of your choosing or run the macro from the “Macro” menu. Click on the “Developer” tab to bring up the ribbon. Click the “Record Macro” button in the Code frame of the Developer ribbon. Type your desired macro name into the “Macro Name” text box, then type the shortcut key you want to use to access your macro in the “Shortcut Key” text box. Click “OK.” For example, you might name your macro “AddEmphasis” and set the shortcut key to “E.” Format your spreadsheet in whatever way you want. Whatever you do now will be repeated when you run the macro in the future. For example, you might italicize the text in a cell and change the background to y
