Can not view VB program

F

FredZack

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

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cAN NOT VIEW VB program 4
VB program 1
VB program runs but does not show. 2
How do I find what is in a spreadsheet 4
When something in module is shown as a macro 3
Can't find "Visual Basic" Toolbar on Excel 2007 Ribbon 3
Excel using VB - save problem 6
VB macros in new Excel 24

Top