[已解决]如何禁止在工作表中操作右键

nothingwmm

如何禁止在工作表中操作右键？ 谢谢
综合楼下答案：

1. Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
   
2. Cancel = True
   
3. End Sub

复制代码

1. Application.CommandBars("Cell").Enabled = False '禁用单元格的右键菜单
   

复制代码

最佳答案

月排行榜 / 总排行榜

迎客松

2011-1-23 18:19

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
End Sub

跳转到最佳答案楼层

迎客松

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
End Sub

nothingwmm

迎客松 发表于 2011-1-23 18:19
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
...

高，谢谢， 我刚才看到的一个是
Application.CommandBars("Cell").Enabled = False '禁用单元格的右键菜单

开辆小富康

嗯。这两个都不错，学习了。楼上的是工作表代码中的，如果工作簿级的就用

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

sunjing-zxl

学习了，不错不错。

yuliang-1918

很好，学习了