Hi all,

I have 2 workbooks A and B in the same directory

The Workbook Before_Close module of A contains a line;
ThisWorkbook.Close False

While workbook A is open, I open the other workbook (B). Then I close workbook A. Therefore I automatically fall into workbook B. But I can not edit this workbook and it gives an error, after which Excel closes erroneously. But when I remove the line ThisWorkbook.Close False from workbook A, there is no problem.

Now, I want workbook A to be closed without saving, but if the user opens another workbook in the meantime, I don't want him to face this problem. What can be done?

Adnan Buran