VBA: Recording a macro in Excel 2007

In this presentation you will see how to record a simple macro in Excel 2007. In this example you will see how to record a macro that does something little on the sheet. You will also see how to use the macro.

Presentation type: Flash SWF
Software needed to apply: Microsoft Office Excel 2007

Open the presentation here.

VBA: Creating a macro in Excel 2007

In this presentation you will see how to create a simple macro in Excel 2007. In this example you will see how to create a sub-routine in a separate code module and how to assign a button - added on the sheet - to a macro.

Presentation type: Flash SWF
Software needed to apply: Microsoft Office Excel 2007

Open the presentation here.

VBA: Saving Excel macro-enabled workbook

In Excel 2007, you must save your workbooks containing VBA macros as a macro-enabled workbook. Otherwise, your macros will not be saved. The picture below illustrates how to save your workbook enabled with macros. Click on the picture to see it in it's original size.


Picture 1. Save as Excel macro-enabled workbook.

VBA: Macro tools in Excel 2007

In Office 2007 applications macro tools can be enabled by adding the Developer tab in the Office ribbon. To do this in Excel, click the office button and then click Excel Options. In the Excel Options dialog check the Show Developer tab in the Ribbon. Click OK. Now the Developer tab should appear in the ribbon. See picture 2.

The picture below illustrates checking the Show Developer tab in the Ribbon option. Click on the picture to see it in it's original size.


Picture 1. Show Developer tab in the ribbon option.

The picture below illustrates the Developer tab in the Excel ribbon. Click on the picture to see it in it's original size.


Picture 2. Developer tab.