uneditable cells (excel 2000)

[knini]

Is there any way that I can make the cells read only? For example, I just finish working on a spreadsheet, which contains some important formula and data. Someone else will looked at the sheet and add some more info. However, I don

[Rudi]

The quickest way to do this is to Protect the sheet!
Choose TOOLS | PROTECTION | PROTECT SHEET, type in a password and choose OK!

[GoCush]

If you want to allow other users to add something in other cells, you will need to select those "other" cells and unlock them BEFORE protecting the worksheet.

But, keep in mind this will only keep the average user from removing your protection. Most people who view these newsgroups or forums will be able to remove your protection within a matter of seconds.

Excel spreadsheet security is really mostly a joke.

[LegareColeman]

1- Select all of the cells that you want other people to be able to change.

2- Select Cells from the Format menu, and then click on the Protection tab in the resulting dialog box.

3- Click on the check mark next to Locked to remove the check mark, then click on OK.

4- Click on Protection on the Tools menu, then click on Protect Sheet on the fly out menu.

5- Type a password in the dialog box to keep the other user from being able to unprotect the sheet without the password (Excell passwords are not hard to break if you know how).

6- Click on OK

You should now only be able to modify the cells that you unlocked.