在需要屏蔽的工作簿的thisworkbook中写入宏
Private Sub Workbook_Activate()
Application.CommandBars(1).Controls("文件(&F)").Enabled = False
Application.CommandBars(1).Controls("编辑(&E)").Enabled = False
Application.CommandBars(1).Controls("视图(&V)").Enabled = False
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars(1).Reset
End Sub
在需要屏蔽的工作簿的thisworkbook中写入宏
Private Sub Workbook_Activate()
Application.CommandBars(1).Controls("文件(&F)").Enabled = False
Application.CommandBars(1).Controls("编辑(&E)").Enabled = False
Application.CommandBars(1).Controls("视图(&V)").Enabled = False
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars(1).Reset
End Sub