怎样用vb编程,实现保护excel,让其不可修改,不可选择,不可复制?我用了
excelObj.ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
excelObj.ActiveSheet.EnableSelection = xlNoSelection
这两句,虽然能不让修改,但是还是能选中单元格,能够复制,想问一下怎么才能实现我上面说的要求呢!
excelObj.ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
excelObj.ActiveSheet.EnableSelection = xlNoSelection
这两句,虽然能不让修改,但是还是能选中单元格,能够复制,想问一下怎么才能实现我上面说的要求呢!
首先,确定 Excel 是否支持这样的功能。如果支持,在 Excel 中手工设置的同时记录宏,把代码移植到 VB 中即可。
Dim ctl As CommandBarControl
With Application
.OnKey "^{x}", ""
.OnKey "^{c}", ""
.OnKey "^{v}", ""
End With
For x = 1 To 3
For Each ctl In CommandBars(Array("Standard", "Edit", "cell")(x - 1)).Controls
Select Case ctl.ID
Case 19, 21, 22
ctl.Enabled = False
End Select
Next
Next
End Sub
http://topic.csdn.net/u/20081204/22/28641819-f62c-4428-bb33-882e3c05c840.html