How Do You Use Macro In Excel 2007?
Excel macros are units of executable code that you can use to easily eliminate tasks in Excel 2007. The Excel macro function works like a tape recorder—recording your actions for you to replay as many times as you want. From fully formatting documents to performing complex mathematical calculations, there’s no limit to what commands an Excel macro can replace; you can even use a macro to perform a simple task that you perform frequently: like changing font size or cell color. Click the “Developer” ribbon. Click ‘Record Macro” in the Code section of the developer ribbon. Type a name for the macro into the “Macro Name” text box. For example, if you want to make a macro that turns a cell background green, you might name it “GreenCell.” Perform whatever actions you want the macro to execute. For GreenCell you might change the current background color to light green. Click “Stop Recording” in the Code section of the developer ribbon. Click “Macros” in the Code section of the Developer rib
