Friday, August 20, 2010

Installed VBA for Microsoft Excel 2007

If you are using Microsoft Excel 2007, its hurt when by default Microsoft are not included this feature during normal Office 2007 installation. Please follow below step to install it by yourself. You may need the original installation CD to perform this.

How to install VBA for Excel 2007 from your Office CD

1. From the Start button on your bottom left of the screen goto "Control Panel".

2. From "Control Panel" goto "Add or Remove Programs".

3. Select to your "Microsoft Office 2007" and click to "Change" button.

4. Select "Add or Remove Features" and click on "Continue"

5. Installing option windows prompt out and click on "Office Shared Features".

6. Once "Office Shared Features" selected, goto "Visual Basic for Applications" enable and "Continue".

7. Wait until your computer complete installing VBA.
8. VBA is installed and you need to show the "Developer" item on your toolbar. Click on office Toolbar on the upper left corner of your Excel application. See below Image.

9. Then select "Excel Option" as below.

10. Now Excel Option window prompt out and make sure all item on below picture are checked.
11. Now open "Microsoft Excel 2007" and you will notice a new Menu shows "Developer" on the screen. As shown on below is the features for Office 2007 VBA.

Change "Macro Security" level
On "Developer" menu you'll notice a "Macro Security" menu click this to set your security as below.


No comments:

Post a Comment

Please add if your have better information.