Double click on the name to execute a command. When you click on it you will see the Macro window where you can select the one you need. The macros you save are stored on the Macros button. Then go to the Macros icon and select the Stop Recording option.For example you can write the value Hello in the A1 cell. Optionally you can write the description. Write the Macro name (it does not accept spaces or special characters), the shortcut key and select where you want to store your macro in in the corresponding field. Choose the Record Macro from the Macros drop-down list: To begin with click the View tab on the Ribbon.In this sample I am using Excel 2010, but you can use 2007 version as well. This article contains some nice and simple Examples to automate your daily tasks in Excel.Ī Macro is a program in Visual Basic used to automate Office Tasks. Many people think that it is extremely hard to learn Excel Macros, but it is not. Create Macros using Record Macro Button.
0 Comments
Leave a Reply. |