file not found ...\local~\temp\vb514.tmp

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