Hi
you may show the code in your workbook_open event and in your
workbook_beforeclose event

--
Regards
Frank Kabel
Frankfurt, Germany


I'm wondering if anybody has come accros a problem similar to this.


I have a workook which when it opens begins an automatic update
process. When the process is complete the workbook is to close.
However, in the code in the close event it won't executet he code.
There are no errors the code just doesn't perform.

For example the one line of code is Me.Save. The workbook does
nothing. Now if I insert a Cancel = True, then abort the code, and
then close the workbook manually when I step through the code
everything works perfectly.


I use a OLE object and I'm wondering if that could be the cause.
However, I use the same object in other books without issue. Has
anybody ever seen this problem and it's cause?


---
Message posted from http://www.ExcelForum.com/