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?

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?
>