Questions

linked password protected excel 2007 worksheets

+
0 Votes
Locked

linked password protected excel 2007 worksheets

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.
  • +
    0 Votes

    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.

  • +
    0 Votes

    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.