Protection of cells in a worksheet

[smg201]

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.

 

[Gord Dibben]

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

First you should select all cells and unlock them through
Format>Cells>Protection.

Then select the ones you want locked and lock them through
format>cell>protection.

Now go to Tools>Protect Sheet.

Instructions are for 2003 version.

For 2007.............Home>Fomrat>Format Cells>Protection.

Review>Protect Sheet


Gord Dibben MS Excel MVP

 

[trip_to_tokyo]

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!