To run a macro: Click Tools > VBA Macros > Manage > Run the macro you want from the list of macros you've created for the sheet. You can also assign a macro to a button and run the macro just by clicking the button.
To assign macros to a button: 1. Click the Advance Options on the top-right corner of the button or right click on the button. 2. Select Assign an Existing Macro. 3. In the macro list that appears, choose the desired macro and click "Assign". 4. To ...
To record a macro: Click Tools > VBA Macros > Record. Name the macro and continue recording. Note that the macro name can only consist of alphabets, numbers and underscore characters. Click on the box near Use Relative Reference if you want the cell ...
To create a macro: Click Tools > VBA Macros > Create. The Create Macros menu is displayed. Name the macro that you wish to create. You can also describe the functioning of the macro. Note that the macro name can only consist of alphabets, numbers ...