Hi Dave

Many thanks for your code which is a lot neater than my effort.

I have tried your suggestion of *saving as * to the temp folder but it
wont save that way either. However, if I try to open the file again it
says there is another copy already open.

The NT4 event viewer records an event ID 3009 'The redirector failed to
unlock part of a file on the server'.

If there is no solution to this, I am thinking of enabling Autosave to
run every 10 mins. Is there likely to be any confict between Autosave
and running any of my macros? If so I presume I could switch it off at
the beginning of each one. Any thoughts on this?

Thanks again

Paul


--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=276187