Enabling VBA in Your Copy of Excel:-


1. By default, VBA is disabled in Office 2007.

2. Before you can start using VBA, you need to enable macros in the Trust Center.

3. From the Office icon menu, you choose Excel Options, Trust Center, Trust Center Settings, Macro Settings. Then you choose Enable All Macros.

4. Further, when you save your files, you have to save the files as Excel 2007 macro-enabled workbooks, with the .xlsm extension.