Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
2. To open the Save As dialog box, select Save As.
3. In the Save As dialog box, click the Tools button and select General Options (refer to
The General Options dialog box opens.
4. Clear the Password to Open input box as well as the Password to Modify input box and
5. Save your file.
When you select the Read-Only Recommended check box in the General Options dialog
box (refer to Figure 19-4), you get a cute but useless message recommending read-only
access upon opening the file. This message is only a recommendation and doesn’t
prevent anyone from opening the file as read/write.
Limiting access to specific worksheet ranges
You may find that you need to lock specific worksheet ranges, preventing users from taking certain
actions. For example, you may not want users to break your data model by inserting or deleting
columns and rows. You can prevent this by locking those columns and rows.
Unlocking editable ranges
By default, all cells in a worksheet are set to be locked when you apply worksheet-level protection.
The cells on that worksheet can’t be altered in any way. That being said, you may find you need
certain cells or ranges to be editable even in a locked state, like the example shown in Figure 19-5.
Figure 19-5: Though this sheet is protected, users can enter 2006 data into the input cells provided.
Before you protect your worksheet, you can unlock the cell or range of cells that you want users to be
able to edit. (The next section shows you how to protect your entire worksheet.) Here’s how to do it: