View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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?