Chip Pearson Wrote:
My guess is that the workbook is bordering on the edge of
corruption. Something is not right in the way it stores or
displays the VBComponents in the project explorer. Whether this
will mushroom into wider corruption is anybody's guess. I would
recreate the workbook in a new workbook. If you don't you might
find yourself unable to open the document at all.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Kevin Vaughn" wrote in
message
...
I had a problem with a worksheet where the formulas were not
recalclulating.
I essentially solved it by renaming my worksheet (to
SummaryBak) and using a
new worksheet I named Summary. This morning, while changing
the codename of
Summary, I noticed that, the worksheet SummaryBak was not
showing up in the
VBE (in the window that lists the Projects, probably called
Projects window.)

Thanks.
--
Kevin Vaughn
It's not worth taking that chance, so I'll do that. Thanks.


--
Kevin Vaughn
------------------------------------------------------------------------
Kevin Vaughn's Profile: http://www.excelforum.com/member.php...o&userid=34857
View this thread: http://www.excelforum.com/showthread...hreadid=550375