Error closing Excel after running series of macros

I have a template that users input preferences via a user form.
The macros then creates a copy of a worksheet and removes ranges based on
the parameters the user enters.

It works like a charm. It saves the file no problem. But when I try to
close Excel or even just the file, Excel is no responsive and then gives me a
message apologizing for inconvenience but some data might be lost. (the data
is never really lost).

There is no runtime error generated. I have no idea how to trap this. I am
running OS XP, Excel 2002 SP3.

This is really driving me bats. This file is distributed to 700 people and I
am getting tired of shrugging and saying I cant fix it.

Anybody seen this?

Consistent/reproducible error ?

Difficult to help without seeing any code...

Tim

--
Tim Williams
Palo Alto, CA


"PT_VBA_GRRL" <[email protected]> wrote in message
news:[email protected]...
> I have a template that users input preferences via a user form.
> The macros then creates a copy of a worksheet and removes ranges based on
> the parameters the user enters.
>
> It works like a charm. It saves the file no problem. But when I try to
> close Excel or even just the file, Excel is no responsive and then gives
me a
> message apologizing for inconvenience but some data might be lost. (the
data
> is never really lost).
>
> There is no runtime error generated. I have no idea how to trap this. I
am
> running OS XP, Excel 2002 SP3.
>
> This is really driving me bats. This file is distributed to 700 people and
I
> am getting tired of shrugging and saying I cant fix it.
>
> Anybody seen this?