Usually you turn it off to solve problems when double clicking excel files


--
Regards,

Peo Sjoblom



"nathan" wrote in message
...
Because in the course of researching how to resolve the problem, someone
suggested turning this on. I then realized that just toggling this on and
off solves the problem for one iteration. So, it seems related. Thanks.

"Peo Sjoblom" wrote:

Why do you use "ignore other applications" at all?



--
Regards,

Peo Sjoblom



"nathan" wrote in message
...
Hello,

This is driving me crazy. When I try to create a copy of a worksheet I
get
the following error: c:\...\local~\temp\vb514.tmp. If I then turn off
"ignore other applications" I can do the copy. But the very next time
I
try
a worksheet copy the same error occurs. If I then toggle "ignore other
applications" ON, it solves it. So, it seems all I need to do is
toggle.

The spreadsheet I copy has macros in it. If I cleanse the workbook of
macros by saving as .xml, then rename as .xls, the problem is solved.
But
as
soon as I add macros the problem comes back. Even if I don't add back
macros, but simply have the VB editor open, the problem occurs. I
also
get
prompted to enter the password for "funcres", which I have no idea what
is.

The problem occurs on other machines with the same spreadsheet. I
deleted
all my temp files but no luck. Seems to be only with this spreadsheet.
The
spreadsheet was created in 2003. I am using Excel 2003.

Thanks for your help,
Nathan