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

application.sendkey "^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

Sorry here is the code
Application.OnKey "{ESC}", ""
Application.OnKey "^{BREAK}", ""
Application.OnKey "^{PGDN}", "" 'Disable Ctrl-PageUp
Application.OnKey "^{PGUP}", "" 'Disable Ctrl-PageDown

Application.OnKey "^{s}", ""
Application.OnKey "^{c}", ""
Application.OnKey "^{g}", ""
Application.OnKey "^{n}", ""
Application.OnKey "^{f}", ""
Application.OnKey "^{x}", ""

"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

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