Just to add to Jim's comments:

Application.OnKey "^s", "" 'save shortcut
Application.OnKey "^S", "" 'saveas shortcut

And to reset them:

Application.OnKey "^s"
Application.OnKey "^S"



PaulC wrote:

Hi Dave

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

I have also included a Save Workbook macro button that also tests for
an error on saving to the network. To stop users saving normally, I
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 be
very grateful if you can enlighten me on this one.

Many thanks,

Paul

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

--

Dave Peterson