每一次,都需要把之前的还原,或者你把visible=true的也设置一下。
msgbox("当前表:" & CurrentTable.Name)
For Each i As object In e.ContextMenu.Items
i.visible = True
Next
If CurrentTable.Name="表A" Then
ContextMenus("test").Items("截图表B").Visible=False
ContextMenus("test").Items("截图表C").Visible=False
End If
If CurrentTable.Name="表B" Then
ContextMenus("test").Items("截图表A").Visible=False
ContextMenus("test").Items("截图表C").Visible=False
End If
If CurrentTable.Name="表C" Then
ContextMenus("test").Items("截图表A").Visible=False
ContextMenus("test").Items("截图表B").Visible=False
End If