|
Posted to microsoft.public.excel.programming
|
|
|
Recovering from temporary loss of network drive - Excel VBA proble
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
|