Sunday, January 27, 2013

How to View VBA Code in Excel 2007


1. Open the workbook in Excel that you would like to view VBA code for. VBA code is workbook specific, meaning it is only attached to one workbook. In order to view the code for a specific workbook, you must have that workbook open.
2. Click on the 'Developer' tab, then click on 'View Code.'
3. Click on a module in the left sidebar. This will open the module and display the VBA in a box on the right side of your screen.

Blogger news