Protection of cells in a worksheet

How do I protect some cells but not others in a worksheet? I want to be able
to protect those cells that I have entered information into and do not want
changed but...at the same time, there are other cells on the same
worksheet/workbook that I want to add/enter information into.

Thank you.

Bt default all cells on a sheet are locked when sheet protection is enabled.

First you should select all cells and unlock them through
FormatCellsProtection.

Then select the ones you want locked and lock them through
formatcellprotection.

Now go to ToolsProtect Sheet.

Instructions are for 2003 version.

For 2007.............HomeFomratFormat CellsProtection.

ReviewProtect Sheet


Gord Dibben MS Excel MVP

On Fri, 4 Sep 2009 09:03:04 -0700, smg201
wrote:

How do I protect some cells but not others in a worksheet? I want to be able
to protect those cells that I have entered information into and do not want
changed but...at the same time, there are other cells on the same
worksheet/workbook that I want to add/enter information into.

Thank you.

Hi SMG201.

Please refer to:-

www.pierrefondes.com

On this website I have put up 2 files for you.

1. The first is a WORD file (test_case_1.doc).

This is a step by step guide to what you want and it explains the EXCEL file
that I have constructed for you (number 2. that follows).

2. The second is an EXCEL file (test_case5.xlsx).

This shows you one Workbook in which you can amend some cells only (those
highlighted in yellow).

I hope that the above meets your requirements.

Please click on Yes if this posting has been helpful to you.

Thanks!





"smg201" wrote:

How do I protect some cells but not others in a worksheet? I want to be able
to protect those cells that I have entered information into and do not want
changed but...at the same time, there are other cells on the same
worksheet/workbook that I want to add/enter information into.

Thank you.