The Record Macro window opens, where you can set up the macro’s name, description, and shortcut keys before you record it. If necessary, turn on the Developer tab.If you do make a mistake while recording a macro, don’t worry-you can always delete the existing macro and try again or edit the macro’s Visual Basic source code to fix the mistake. Practice or rehearse your script a couple times, to make sure it works, before you actually record it. Before recording a macro, it’s helpful to write down a script that contains all the steps you want the macro to record. When you create a macro, imagine you’re being recorded every step you make is being tracked-all your commands, the data you enter, even any mistakes you make. This lesson explains the easy way to create a macro-by recording the task(s) you want the macro to execute for you. There are two ways to create a macro: by recording them or by writing them in Excel’s Visual Basic programming language.
0 Comments
Leave a Reply. |