From other post I realize that you disable the menu item by:
Application.CommandBars("Tools").Controls("Protection").Enabled = False
but, I want to disable it for everyone unless you log on as Administrator.
I have tried the following, but it does not work.
Private Sub Workbook_Open()
If Application.UserName <> "Administrator" Then
Application.CommandBars("Tools").Controls("Protection").Enabled = False
End If
End Sub
I cannot find the solution from other posts