如果你不想使用Excel内置的快捷键,或者不希望你开发的界面因为快捷键而被破坏,你可能会想禁用所有的Excel快捷键。...Array("{BS}", "{BREAK}","{CAPSLOCK}", "{CLEAR}", "{DEL}", _
"{DOWN}","{END}", "{ENTER...StartKeyCombination & Key, ""
Next Key
'禁用StartKeyCombination中每个键与其它键的组合键
For...Array("{BS}", "{BREAK}","{CAPSLOCK}", "{CLEAR}", "{DEL}", _
"{DOWN}", "{END}", "{ENTER..."{PGDN}"
Application.OnKey "{PGUP}"
End Sub
你可以在工作簿打开时禁用所有快捷键,在关闭工作簿时恢复所有快捷键,这需要你在ThisWorkbook模块中放置下面的代码