[rags]

Hi all,

I have tried with the following code Application.OnKey "^{s}", "".
but when i enter any data in the sheet and press "Ctrl S" then the
changes will be applied to the sheet.

i want to disable "ctrl S" completely. please help me out.....

[Tom Ogilvy]

these worked for me:

Sub StopCtrlS()
Application.OnKey "^s", ""
End Sub

Sub RestoreCtrlS()
Application.OnKey "^s"
End Sub

but you have to Execute the code to effect the change.

--
Regards,
Tom Ogilvy




"rags" wrote:

Hi all,

I have tried with the following code Application.OnKey "^{s}", "".
but when i enter any data in the sheet and press "Ctrl S" then the
changes will be applied to the sheet.

i want to disable "ctrl S" completely. please help me out.....