Close a WB, but still in VB Editor Project Explorer

D

Don

When I close a particular workbook (>390KB), I look at the
visual basic editor and the workbook remains in the
project explorer. When I close EXCEL, I get amessage
about a workbook can't be c;osed because it is referenced
by aonther workbook. When I "OK" that message, EXCEL
window disappears, but I get an invalid page fault. EXCEL
remains in the "Close Program" window (CTL-ALT-DEL).
Here's the Fault log entry:

Date 10/10/2003 Time 12:36
EXCEL caused an invalid page fault in
module VBE6.DLL at 017f:6508c2db.
Registers:
EAX=00000000 CS=017f EIP=6508c2db EFLGS=00010246
EBX=65225ec0 SS=0187 ESP=0062e914 EBP=0062eb50
ECX=00000000 DS=0187 ESI=00000027 FS=2b37
EDX=00000000 ES=0187 EDI=004a8ef0 GS=0000
Bytes at CS:EIP:
8b 88 b4 00 00 00 85 c9 0f 84 33 da 09 00 56 8b
Stack dump:
6500b1b7 004a8ef0 0047b8d8 65225ec0 65090565 0248fe84
00000000 00000008 6500b355 02f397d4 00000000 6522596c
02fb92c0 00000000 00000000 828b8994

I got lots of fault log entries like this.

Thanks,
Don

P.S. I have uninstalled and re-installed MS Office several
times to no avail.
 
J

Jan Karel Pieterse

Hi,

This means that *in another project* a reference is set to
that workbook.

To check which, select the projects (in the VBE of course)
one-by-one and check their references (Tools, references).

Regards,

Jan Karel Pieterse
Excel TA/MVP
 

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

Top