Sunday, July 8, 2012

How to View VB in EXCEL 2007

Excel is a powerful application which can be used to develop tools using Visual basic and Macros, apart from it’s usual spreadsheet functionality.To access VB in EXCEL, we can follow the below steps:

1. Click on the Office Button image

2. Click on the EXCEL Options

image

3. Check on the Show Developer Tab in the Ribbon Check Box and click on OK.

image

 

4. You can find the developer Tab has been enabled.

 

image

No comments:

Post a Comment