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?

Two options I can think of
1) Did you share the workbook?
2) Did you password protect the VBProject?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Fred Zack" wrote:

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?

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

On Wed, 11 Feb 2009 15:44:01 -0800, Barb Reinhardt
wrote:

Two options I can think of
1) Did you share the workbook?
2) Did you password protect the VBProject?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Fred Zack" wrote:

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?

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


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62679

How do I do this?

"mdmackillop" wrote:


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


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62679

For each WorkSheet in the VBIDE Project Explorer:

Click the Worksheet.
Click View Source

See if you find the VBA there.