Hi Manish,
Enter the following code in workbook. (Press Alt + F11 -> double click on
this workbook -> Choose "workbook" from first filter drop down and "Open"
from second filter drop down.
Private Sub Workbook_Open()
MsgBox "Dont use command like 'Ctrl+X' OR edit in 'green field only"
End Sub
Be
If you are REALLY concerned about the users of your workbook using
specific commands you could also turn them off by using the OnKey
method in the Workbook_Open event handler. Here's the code on how to
do that for "CTRL+X":
Private Sub Workbook_Open()
Application.OnKey "^{x}", ""
End Sub
Che
