If a workbook is protected you will lose the close/maximize/and minimize options. This is a common problem. To avoid this you can limit changes to an entire workbook without selecting window protection. On the Tools menu, point to Protection, and then click Protect Workbook.
To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed and new worksheets can't be inserted, select the Structure check box. To use windows of the same size and position each time the workbook is opened, select the Windows check box.
To prevent others from removing workbook protection, type a password, click OK, and then retype the password in the Confirm Password dialog box. Passwords are case sensitive. Type the password exactly as you want to enter it, including uppercase and lowercase letters. When you assign a password, write it down and keep it in a secure place. If you lose the password, you cannot gain access to the protected workbook elements.
Note: If you add a password-protected workbook to a binder, the password protection is lost. You will be prompted to enter the password when you add the workbook to the binder, but the protection is removed after it becomes a binder section.
Talk To Other Members