Excel VBATutorial           

             

Excel VBA Macros

Email to excel-vba.com

Excel Tutorial on Macros

 Excel Consulting

How to install VBA for Excel 2007 from your Office CD

Print this webpage and follow the instructions

Note: Users of Excel (2010) or earlier versions (1997 to 2003) do not need to install anything. This installation procedure is for users of Excel 2007 ONLY.

In Excel in 2007 the user needs to install VBA for Excel to be able to develop, maintain or modify macros.

This is how to do it:

- Click on the "Start" button at the bottom of your screen and chose "Control Panel".

Office Control Panel

- Double click on "Add or Remove Programs"

Office program add remove

- Select "Microsoft Office"( it can read "Enterprise 2007 or "Home 2007...) from the list of programs

Office cd

- Click on "Change"

Office program change

- Select "Add or Remove Features" and click on "Continue"

Office setup

- Expand "Office Shared Features" with the + sign

Windows office programs

- Select "VBA for Application" and click on "Continue"

VBA Installation

Now that VBA is installed you need to show the "Developer" item on your toolbar. To do so click on the Office button:

Start button

then select "Excel Options" at the bottom of the window:

Excel options

Select "Popular" and check "Show Developer in the Ribbon":

Excel popular options

You should now see a new item on your Excel menu bar "Developer" and you can develop macros when you are ready.


Back to the Table of Contents