Situation:
Excel 2000
Two or more workbooks contain BeforeClose procedures.
When each workbook is closed separately the BeforeClose routine in each workbook works flawlessly.
Problem:
If the workbooks are open and Excel is closed, then only the first
BeforeClose routine is executed, and Excel and all of the workbooks
remain open, including the one whose BeforeClose procedure runs.
Experimentation:
There are no "On Error Resume Next" statements in the BeforeClose code.
I've stepped though the BeforeClose routines and there are no VBA errors generated.
The "failure to terminate" seems to occur, after the first BeforeClose routine
finishes but when Excel fails to continue and execute the next BeforeClose
routine.
Solution:
???
TIA
JH
Excel 2000
Two or more workbooks contain BeforeClose procedures.
When each workbook is closed separately the BeforeClose routine in each workbook works flawlessly.
Problem:
If the workbooks are open and Excel is closed, then only the first
BeforeClose routine is executed, and Excel and all of the workbooks
remain open, including the one whose BeforeClose procedure runs.
Experimentation:
There are no "On Error Resume Next" statements in the BeforeClose code.
I've stepped though the BeforeClose routines and there are no VBA errors generated.
The "failure to terminate" seems to occur, after the first BeforeClose routine
finishes but when Excel fails to continue and execute the next BeforeClose
routine.
Solution:
???
TIA
JH