In the Excel 2007, you have to manually install VBA to be able to develop, maintain and update macros.

Here is the process of how to install VBA for Excel 2007.

Step 1: Click on the “Start” button at the bottom of your screen and chose “Control Panel”.