I have found that setting the window.caption to something new causes this
problem.

I started a new thread with this detail included.
--
JC


"jc" wrote:

I have a workbook created from a template.
I has one event subroutine Workbook_BeforeClose
In my code I activate the workbook

Workbook.activate

Even though another sheet was previously active this line of code activates
the workbook and makes Sheet(1) the active worksheet.

This is not the behavior with other workbooks. The previously active sheet
stays is activated.

Is there some setting causing this?

--
JC