Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to prevent excel users from changing the worksheet name and worksheet order while preserving the filename as .xls or .xlsx instead of having to change it to .xlsm?

Please advise.

share|improve this question

migrated from Jun 10 '13 at 4:47

This question came from our site for professional and enthusiast programmers.

Yes; protect the workbook to achieve this. – Pieter Geerkens Jun 10 '13 at 4:16

As stated in my comment, you can protect the workbook to achieve this.

You can then password protect the workbook to completely prevent changes, or leave the password blank to simply "remind" users of the constraint.

In the dialog box that comes up, select the structure check box.

share|improve this answer

You must log in to answer this question.