Solved: Preventing Workbook & Sheet Protect

[pcsparky]

Can a workbook be coded to prevent users from using the Tools-Protect Sheet or Protect Workbook menu options?

[Simon Lloyd]

You could try this line (untested)CommandBars("Worksheet menu bar").Controls("Tools").Controls("Protection").Enabled = False

[pcsparky]

I managed to find something else similar before the forum crashed and change it a little to this:

Application.CommandBars("Tools").Controls("Protection").Enabled = False

which works fine.

[Simon Lloyd]

If you query is now solved could you mark the thread solved by going to Thread Tools>Mark Thread Solved