Question

Locked

linked password protected excel 2007 worksheets

By geoff.atkins ·
In Excel 2007 we create "feeder" worksheets which are saved with a password to prevent opening the file. These worksheets are linked to a "master" worksheet, the data source of which needs to be changed to one of the "feeder" worksheets. Excel 2007 requires the password to be re-entered repeatedly for every cell which is updated. Can this be resolved.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Locking & Unlocking Cells

Excel can protect cells, graphics, charts, and other worksheet objects. This protection will take effect only after you turn on the Worksheet Protection option in the Protect Sheet dialog box. If you enable protection, no changes can be made to a cell until you unlock that cell.
Locking Cells

You can easily lock any cell in a worksheet.

NOTE: Make sure to lock the cells before you protect the sheet or document. Once a sheet or a document has been protected, you cannot access menu selections that allow you to make changes to cells.

1.

Select the cell(s) to be locked
2.

From the Ribbon, select the Home command tab
3.

In the Cells group, click FORMAT
4.

In the Protection section, select Lock
NOTE: If the icon is highlighted, the cells are locked.
5.

Protect the worksheet

Unlocking Cells

In order to unlock cells, sheet protection must first be turned off. For more information, refer to Worksheet Level Protection or Workbook Level Protection.

1.

Unprotect the worksheet
2.

Select the cells you want to unlock
3.

From the Ribbon, select the Home command tab
4.

In the Cells group, click FORMAT
5.

In the Protection section, deselect Lock
The cells are unlocked.
NOTE: If the icon is not highlighted, the cells are unlocked.

Hope this works for you.

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums