Is there anything in the code that would cause the workbook to close on
some conditional criteria?

<FYIThe only way to lose the macro security (& associated warnings) is
to use an automated instance of Excel.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc