The following macros will work with Excel 2000. Not sure if they'll work in 97:
' Macro to turn off keyboard entry.
Sub KeyboardOff()
' Sets CTRL+D to activate KeyboardOn.
Application.OnKey "^d", "KeyboardOn"
Application.DataEntryMode = True
End Sub
Note that the above macro is only applicable to the Active Sheet. If sheet is changed, keyboard operation is enabled
' Macro to restore keyboard entry.
Sub KeyboardOn()
Application.DataEntryMode = False
End Sub
This message was edited by hedrijw on 2002-10-29 14:02