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?