Microsoft Excel 2007 Tutorial - Workbook Security

Microsoft Office Excel 2007 provides many ways to protect and protect your work. For maximum security, you must protect the entire workbook file with a strong password. Excel passwords can contain up to 255 letters, numbers, spaces and symbols and are CaSe SeNsItIvE. For additional data protection within your workbook, you can protect certain sheets or workbook items with or without a password. Protecting worksheets or workbook items can prevent users from accidentally or significantly changing, moving, or deleting sensitive data.

In this Microsoft Excel 2007 study guide, I will show you how to create a password to protect your workbook and how to protect certain elements of a workbook. There are many Excel tips and tricks to help you become an Excel expert. I have other Excel tips as part of my Microsoft Excel 2007 series of tutorials that I hope you find useful.

SAFETY WORK SAFETY

To ensure the security of your entire workbook, you can specify two separate passwords:

• Open and view the book. This is an encrypted password that unauthorized access to your book prevails. You can also give users the ability to open in read-only mode if they simply view the data. This can help prevent accidental changes.
• Change the book. This is an unencrypted password, intended only to give specific users the right to edit a workbook.

These passwords apply to the entire book, and they do not have to be the same password. In fact, it is much safer to use different passwords. To provide reliable protection, you can use both functions. Speaking of strong, strong passwords, we combine upper and lower case letters, numbers and symbols. sweetheartone not strong but Sw33tH3ArT0nE strong.

To protect a book with a password:

1. Click the Microsoft Office Button, then click Save As, then select Excel Workbook. Yes, do it for an existing book.
2. In the lower left corner of the Save As dialog box, click the Tools button and select General Options.
3. To allow users to enter a password when opening a file, enter the password in the "Password to open" field.
4. To allow users to enter a password that allows them to create and save changes, enter the password in the "Password to change" field.
5. To protect users from accidentally modifying a file, select the Read Only check box. Users will be asked if they want to open the file for reading only. THE NOTE! If you have created a password to change, the user, when prompted to enter this password, will be able to open only for reading. Therefore, this parameter is not required when using a password to change.
6. Click "OK".
7. You will be prompted to re-enter your passwords to confirm them. Click OK after confirmation.
8. Click the Save button.
9. If this is an existing workbook and you use the same file name, you will be prompted to click “Yes” to replace the existing workbook.

Microsoft Office Excel 2007 provides options for protecting your data from being modified or deleted by protecting worksheet items and security of workbook items. For other tips and tricks from Microsoft Office Excel, see my other articles in the Microsoft Excel 2007 Tutorial Series.

SECURITY OF ELEMENTS OF THE SEMINAR

1. On the sheet you want to protect, unlock any cells or ranges that you want other users to change:
2. Select each cell you want to unlock, or select the whole range of cells.
3. On the Home tab, in the Cells group, click the Format button and then Format Cells.
4. On the Protection tab, uncheck the Blocked box.
5. You can hide formulas that you do not want users to see:
6. Select the cells that contain the formulas you want to hide.
7. On the Home tab, in the Cells group, click Format, and then Format Cells.
8. On the Protection tab, select the Hide check box, then click OK.
9. If you want to unlock objects, such as images, clips, or shapes, follow these steps:
10. Hold [CTRL] by clicking every object you want to unlock. Drawing tools or drawing tools will appear on the screen by adding the Format tab. THE NOTE! Do not select objects of different types, since the launch of the launch dialog box will not be initialized.
11. On the Format tab in the Size group, click the Dialog box next to Size.
12. On the "Properties" tab, uncheck the "Locked" box. If there is, uncheck the Block text box.
13. Click the "Close" button.
14. On the Overview tab in the Changes group, click Protect Sheet.
15. In the Allow all users of this sheet list, select the items that you want to allow users to edit.
16. In the “Password to unprotect sheet” field, enter the password for the sheet, click “OK”, then confirm the password. This is an optional password. If you do not use it, then any user can unprotect the sheet and modify protected items.

SAFETY OF THE ELEMENTS OF THE WORK BOOK

You use the protection of the elements of the book to prevent, in particular, users:

• View the worksheets you have hidden
• Move, delete, hide or change worksheet names
• Insert a new sheet or charts
• Move or copy worksheets to another book
• Pivot table reports display source data for a cell in a data pane or page field pages are displayed on separate sheets.
• Record new macros

1. On the "Overview" tab in the "Changes" group, select "Protect Workbook" and select "Protection Configuration" and "Windows".
2. To protect the workbook structure, select the "Structure" checkbox.
3. To have workbook windows of the same size and position each time a workbook is opened, select the Windows check box.
4. To prevent users from removing this workbook protection, in the Password field (optional), enter the password, click OK, then confirm it. This is an optional password. If you do not provide a password, any user can unprotect the book and change the protected items.

Excel security is an important feature that can help protect your data.