Hi Dave

I have, at last, got a procedure to work thatwill save the main file'
data to a temp file on the local drive if the network has bee
interupted. A separate macro is then be used to replace the data whe
the network is available again.

I have also included a Save Workbook macro button that also tests fo
an error on saving to the network. To stop users saving normally,
have removed the Save icon and the Save entry in the File menu
However, I don't know the VBA code to stop them using CtrlS. I would b
very grateful if you can enlighten me on this one.

Many thanks,

Pau

--
Paul
-----------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...nfo&userid=756
View this thread: http://www.excelforum.com/showthread.php?threadid=27618