ExcelBanter - Cell Protection

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell Protection (https://www.excelbanter.com/excel-worksheet-functions/230016-cell-protection.html)

I need to protect only certain cells in a spreadsheet (mainly those that
contain a formula) so that no one can accidentally delete them. However, I
need all of the other cells to allow input (eg: dates) and even formatting
(bold, etc...) without a password. How can I do this?

pen wrote...
I need to protect only certain cells in a spreadsheet (mainly those that
contain a formula) so that no one can accidentally delete them. *However, I
need all of the other cells to allow input (eg: *dates) and even formatting
(bold, etc...) without a password. *How can I do this?

Modify the Normal style so that the default cell protection setting is
unlocked (Format Style..., select Normal in the Style name drop-down
list, click the Modify button, select the Protection tab in the Format
Cells dialog, uncheck the Locked checkbox, click OK). Now select the
cells you want to protect, run Format Cells..., and check the Locked
checkbox in the Protection tab of the Format Cells dialog.

For worksheets with existing contents, you may need to select
formatted cells that you want protected/unprotected and change their
protection 'format' to locked/unlocked, respectively. This would be
necessary because formatted cells by virtue of having been formatted
won't be in Normal style.

By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

FormatCellsProtection is where you would change the "locked" or "unlocked"
status.

Select all cells and unlock them.

Select the cells to be locked and lock them

Then ToolsProtectProtect Sheet.

Note the selectable options under "allow users to" when protecting.

Gord Dibben MS Excel MVP

On Wed, 6 May 2009 11:23:03 -0700, pen
wrote:

I need to protect only certain cells in a spreadsheet (mainly those that
contain a formula) so that no one can accidentally delete them. However, I
need all of the other cells to allow input (eg: dates) and even formatting
(bold, etc...) without a password. How can I do this?