cAN NOT VIEW VB program
 

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?

cAN NOT VIEW VB program
 

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?

cAN NOT VIEW VB program
 

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?

cAN NOT VIEW VB program
 

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

cAN NOT VIEW VB program
 

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

cAN NOT VIEW VB program
 

For each WorkSheet in the VBIDE Project Explorer:

Click the Worksheet.
Click View Source

See if you find the VBA there.