How do I create my own macro?

Record a macro with a button

1. Click View > Macros > Record Macro.
2. Type a name for the macro.
3. To use this macro in any new documents you make, be sure the Store macro in box says All Documents (Normal.
4. To run your macro when you click a button, click Button.
5. Click the new macro (it’s named something like Normal.

How do I create a free macro in Excel?

To save it as a macro-enabled workbook:

1. Click No.
2. In the Save As box, in the Save as type list box, choose Excel Macro-Enabled Workbook (*. xlsm).
3. Click Save.

How do you create Excel macros and automate your spreadsheets?

To create a macro, go to View > Macros > Record Macro. Assign the macro a name (no spaces) and click OK. Once this is done, all of your actions are recorded – every cell change, scroll action, window resize, you name it. There are a couple of places which indicate Excel is record mode.

How do I write a macro script?

To run a script by using a macro, create the macro in Visual Basic for Applications (VBA).

1. Open the data file that is associated with the script that you want to run.
2. Press Alt+F11.
3. In the VBA Editor, under Microsoft Excel Objects, double-click the sheet that contains the data you want to run.

How do I create a Personal macro Workbook?

To create the personal workbook, you first need to create a macro and store it in the Personal Macro Workbook.

1. On the Developer tab, click Record Macro.
2. In the Record Macro dialog box, type a meaningful name for the macro in the Macro name box.
3. In the Store macro in box, select Personal Macro Workbook.
4. Click OK.

How do I code an Excel spreadsheet?

Copy Excel VBA Code to a Regular Module

1. Copy the sample code that you want to use.
2. Open the workbook in which you want to add the code.
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor.
4. Choose Insert | Module.
5. Where the cursor is flashing, choose Edit | Paste.