EXcel 禁用/恢复 复制粘贴功能
来源:百度文库 编辑:神马文学网 时间:2024/07/05 11:18:51
禁用/恢复 复制,粘贴功能,代码如下:
Sub DisableCopyCutAndPaste()
EnableControl 21, False ' 剪切
EnableControl 19, False ' 复制
EnableControl 22, False ' 粘贴
EnableControl 755, False ' 选择性粘贴
Application.OnKey "^c", "Dummy"
Application.OnKey "^v", "Dummy"
Application.OnKey "+{DEL}", "Dummy"
Application.OnKey "+{Insert}", "Dummy"
Application.CellDragAndDrop = False
Application.OnDoubleClick = "Dummy"
CommandBars("ToolBar List").Enabled = False
End Sub
Sub EnableCopyCutAndPaste()
EnableControl 21, True ' 剪切
EnableControl 19, True ' 复制
EnableControl 22, True ' 粘贴
EnableControl 755, True ' 选择性粘贴
Application.OnKey "^c"
Application.OnKey "^v"
Application.OnKey "+{DEL}"
Application.OnKey "+{Insert}"
Application.CellDragAndDrop = True
Application.OnDoubleClick = ""
CommandBars("ToolBar List").Enabled = True
End Sub
Sub EnableControl(Id As Integer, Enabled As Boolean)
Dim CB As CommandBar
Dim C As CommandBarControl
On Error Resume Next
For Each CB In Application.CommandBars
Set C = CB.FindControl(Id:=Id, recursive:=True)
If Not C Is Nothing Then C.Enabled = Enabled
Next
End Sub
Sub Dummy()
MsgBox "Sorry,本功能已被禁止使用!"
End Sub
Sub DisableCopyCutAndPaste()
EnableControl 21, False ' 剪切
EnableControl 19, False ' 复制
EnableControl 22, False ' 粘贴
EnableControl 755, False ' 选择性粘贴
Application.OnKey "^c", "Dummy"
Application.OnKey "^v", "Dummy"
Application.OnKey "+{DEL}", "Dummy"
Application.OnKey "+{Insert}", "Dummy"
Application.CellDragAndDrop = False
Application.OnDoubleClick = "Dummy"
CommandBars("ToolBar List").Enabled = False
End Sub
Sub EnableCopyCutAndPaste()
EnableControl 21, True ' 剪切
EnableControl 19, True ' 复制
EnableControl 22, True ' 粘贴
EnableControl 755, True ' 选择性粘贴
Application.OnKey "^c"
Application.OnKey "^v"
Application.OnKey "+{DEL}"
Application.OnKey "+{Insert}"
Application.CellDragAndDrop = True
Application.OnDoubleClick = ""
CommandBars("ToolBar List").Enabled = True
End Sub
Sub EnableControl(Id As Integer, Enabled As Boolean)
Dim CB As CommandBar
Dim C As CommandBarControl
On Error Resume Next
For Each CB In Application.CommandBars
Set C = CB.FindControl(Id:=Id, recursive:=True)
If Not C Is Nothing Then C.Enabled = Enabled
Next
End Sub
Sub Dummy()
MsgBox "Sorry,本功能已被禁止使用!"
End Sub