cAN NOT VIEW VB program

[Fred Zack]

I inherited a spreadshhet (2007) which has a small VB program that updates a
few cells. It is running ut Can no loner 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 somehting and now I can't. How do I view
this?

 

[Barb Reinhardt]

Two options I can think of
1) Did you share the workbook?
2) Did you password protect the VBProject?

 

[Gord Dibben]

One more thing I can think of.

The code is event code and Fred is looking for a Module with a macro.

Select "Visual Basic" Icon and then open each sheet module or Thisworkbook
module.

Event Code will be in one of those.


Gord Dibben MS Excel MVP

 

[mdmackillop]

Have you checked all of the Sheet code pages. Code is not always in the
first visible code panel.

 

[FredZack]

How do I do this?

 

[gimme_this_gimme_that]

For each WorkSheet in the VBIDE Project Explorer:

Click the Worksheet.
Click View Source

See if you find the VBA there.