Recording Macros in Visual Basic

In Microsoft Excel version 7.0, you can choose the language in which to record a macro.

To choose the programming language in which to record a macro

1. On the Tools menu, point to Record Macro, and then click Record New Macro.

2. Click Options.

3. Under Language, click an option.

In Microsoft Excel version 7.0, you can still record your macros in a workbook that opens each time you start Microsoft Excel. In Microsoft Excel version 4.0, this workbook is called Global.xlm (in Microsoft Excel for Windows) or Global Macro Sheet (in Microsoft Excel for the Macintosh). In Microsoft Excel version 7.0, this workbook is now called Personal.xls or Personal Macro Workbook, depending on the platform (Windows or the Macintosh). Your existing macros still run; new macros are simply recorded in the new workbook. Microsoft Excel version 7.0 creates your new Personal Macro Workbook when you record your first macro.

For more information about recording macros, see "Record a macro" in Help.