禁用形状的右键菜单

问题描述：

有没有一种方法可以禁用诸如VBA中的矩形?

Is there a way to disable the right click menu for shapes like e.g. rectangles in VBA?

我尝试过:

Private Sub Workbook_Open()
'    Application.WindowState = xlMaximized
    Application.DisplayFullScreen = True
    Application.CommandBars("Ply").Enabled = False
    Application.CommandBars("Shapes").Enabled = False
End Sub

但这似乎不起作用.

答

右键单击菜单(又名上下文菜单)不是命令栏.

The right-click menu (aka, context menu) is not a Command Bar.

您可能会通过命令栏的较早名称 Toolbars 或它们的较新名称 Ribbons 来了解它们.

You may know Command Bars by their older name, Toolbars, or their newer name, Ribbons.

尽管您可以捕获和/或禁用工作表上的右键单击事件，此不适用于形状之类的对象.

Although you can capture and/or disable a right-click event on a worksheet, this doesn't apply to objects like shapes.

但是，可以通过保护工作表免受更改(使用或不使用密码)来防止显示上下文菜单.

However, you can prevent the context menu from showing by protecting the worksheet from changes (with or without a password).

如有必要，您可以允许用户进行某些更改，而不能进行其他更改.有关更多信息，请参见

If necessary you can allow some changes, but not others, to be made by the user. More information at this link.

相关推荐