We currently use several macro driven workbooks. The problem we have
recently encountered is that some users are experiencing fatal errors when
having more than one of these workbooks open.

For instance:
I open WorkbookA.xls and enable macros, select a couple validations, run a
query, look at my results. I then open WorkbookB.xls and do the same thing
but now I get a fatal error or I go to close one of the workbooks and get the
fatal error. Anyone have any idea as to what the problem may be? One of the
errors I have seen is: Excel is encountering a problem and needs to close . .
.. .

Without knowing what the macros do, it's difficult to tell. My guess would
be that there is code relative to the ActiveSheet and it's referencing the
other workbook and crashing. Can you post the macros?
--
HTH,
Barb Reinhardt



"Theo Bell" wrote:

We currently use several macro driven workbooks. The problem we have
recently encountered is that some users are experiencing fatal errors when
having more than one of these workbooks open.

For instance:
I open WorkbookA.xls and enable macros, select a couple validations, run a
query, look at my results. I then open WorkbookB.xls and do the same thing
but now I get a fatal error or I go to close one of the workbooks and get the
fatal error. Anyone have any idea as to what the problem may be? One of the
errors I have seen is: Excel is encountering a problem and needs to close . .
. .

I think that is exactly what is happening. The problem is that there are so
many files we are using it would take forever to go through and rewrite the
"activesheet" code. Thanks for your help!

"Barb Reinhardt" wrote:

Without knowing what the macros do, it's difficult to tell. My guess would
be that there is code relative to the ActiveSheet and it's referencing the
other workbook and crashing. Can you post the macros?
--
HTH,
Barb Reinhardt



"Theo Bell" wrote:

We currently use several macro driven workbooks. The problem we have
recently encountered is that some users are experiencing fatal errors when
having more than one of these workbooks open.

For instance:
I open WorkbookA.xls and enable macros, select a couple validations, run a
query, look at my results. I then open WorkbookB.xls and do the same thing
but now I get a fatal error or I go to close one of the workbooks and get the
fatal error. Anyone have any idea as to what the problem may be? One of the
errors I have seen is: Excel is encountering a problem and needs to close . .
. .