How to Open Excel 2007 Macro Editor

In this video tutorial we will show you how to open excel macro editor.


In order to open excel macro editor, open an excel document. Right-click on the “Home” tab and choose “Customize Quick Access Toolbar”.

Open the Customize Quick Access Toolbar

In the appeared excel options window, choose “Popular” tab.

Change the popular options

Check “show Developer tab in the Ribbon”.

Now, go to the “Developer” tab. Click on “record macro”.

Start recording

In the appeared window click “ok” to start recording. When finished – press “Stop recording”.

Stop recording

To use macro, press “Macros”, choose a macro to use and click “Run”.