When you are through, close the macro window by selecting the Close and Return to Microsoft Excel option from the File menu, or press Alt+Q.(You can also paste macro code from other sources, such as ExcelTips.) Visual Basic for Applications will start up and you can write your macro. In the Macro Name box, type a descriptive name you want assigned to the macro you are writing.In the Macros In box (at the bottom of the dialog box), select where you want your new macro stored.Choose the Macro option from the Tools menu, then choose Macros from the resulting submenu.To create a macro from scratch, follow these steps: The second method of creating a macro, writing one from scratch, is much more powerful. First you can record a macro, which is appropriate when you want to record a series of steps you perform quite often. There are actually two ways you can create macros. Some readers may not know how to enter a macro from scratch in Excel. Many of the tips used in ExcelTips rely upon macros in order to run.
