EXCEL - 在工作簿中按下Enter键时清除剪贴板。 [英] EXCEL - Clear Clipboard Whenever Enter Is Pressed Within The Workbook.

问题描述

您好

正在寻找一个VB代码/宏，每当它清除ClipBoard " Enter]键。在工作簿中按下。

Looking for an VB Code / Macros which will clear the ClipBoard whenever "Enter" is pressed within the workbook.

感谢提前。

Thanks in Advance.

推荐答案

在ThisWorkbook对象的代码模块：

Try this in the codemodule of the ThisWorkbook object:

Private Sub Workbook_SheetSelectionChange（ByVal Sh As Object，ByVal Target As Range）

Application.CutCopyMode = False

End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Application.CutCopyMode = False
End Sub

这篇关于EXCEL - 在工作簿中按下Enter键时清除剪贴板。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！