Can not view VB program
 

I inherited a spreadsheet (2007) which has a small VB program that updates a
few cells. It is running but I can no longer see it under the VB window when
you click on Visual Basic button on Developer tab in Excel 2007.

I had seen it previously, but did something and now I can't. How do I view
this?

Can not view VB program
 

In the project window you should see something like this:

Module1
Sheet1
Sheet2
Sheet3
ThisWorkbook

Right click on each one, one at a time, then click "View Code" in the pop up
menu. You should locate the code in one of them.

"FredZack" wrote:

I inherited a spreadsheet (2007) which has a small VB program that updates a
few cells. It is running but I can no longer see it under the VB window when
you click on Visual Basic button on Developer tab in Excel 2007.

I had seen it previously, but did something and now I can't. How do I view
this?