View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Error closing Excel after running series of macros

Consistent/reproducible error ?

Difficult to help without seeing any code...

Tim

--
Tim Williams
Palo Alto, CA


"PT_VBA_GRRL" wrote in message
...
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?