Take the 2-minute tour ×

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 stackoverflow.com 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
add comment

1 Answer

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
add comment

Your Answer

