Microsoft Excel is available with many versions of it and each version of it may be slightly different from the other. Microsoft excel is a word processing software that makes the usage of spreadsheets so as to store the data and make calculations using various formulas and enabled us to store, execute and make calculations through it. In many schools and colleges, Microsoft excels serves as a data processing unit, enabling them to maintain a record of their students as well as staff. Talking about Macros, these can be added or deleted using the Visual Basic Editor which can be done as follows:-
How to Write Macros in Excel
1. Creating a Macro:-
First of all, in order to create a macro you will need to record it. There is an option to delete or record macro at the top right hand side of any Microsoft excel document and this option can be bought in use for recording the macro. The macro recorder will record all the steps required to complete the actions that you want your macro to perform.
2. In Case the Developer Tab Is Not Available:-
In case the developer tab comes to be unavailable out of Visual Basics Editor, the file tab needs to be clicked and then select the options. Then in the customize ribbon category, you need to select the developer checkbox and then make a click on OK button.
3. Setting the Security Level:-
To set the security level temporarily to enable all the sorts of macros, you will need to reach the developer tab and then in code group, click the macro security option. Now under the macro settings you will need to enable all the macros and then in code group make a click on record macro option. Now the name for macro can be entered in the macro name box. Keep in mind that the first name of macro must be a letter, and in order to have a shortcut key assigned for running a macro, you will then need to type any lowercase or uppercase letter that you wish to use.
In store macro list, you will then need to select the workbook where you want to store the macro and then in description box, you will need to type a description of the macro as well. Then click the Ok button and start recording.
4. Using A Visual Basic Editor:-
Using a Visual Basic Editor, the macro can be created simply clicking the file tab, click options and then click the customize ribbon button. Now in it, select the developer, check box and then click OK. Set the security level afterwards and then make the desired changes.