RE: Protecting cells

From: JLatham <JLatham_at_discussions.microsoft.com>
Date: Sat, 1 Jul 2006 08:10:01 -0700

Just two things to add to what has already been said.

You mentioned three conditions (free access to a cell, can't change formula, can't do anything). I think the "unable to change at all" comes from one of the options when you use the Protect sheet function. There are several options as to what to allow or disallow while the sheet is protected. One of those options is "Select Locked Cells". Normally that is permitted. But if you clear that checkbox, then the user is not even allowed to select a locked cell once the sheet is protected. Excel then goes to the next unlocked cell when a user presses the enter or tab key while on a sheet like that. This can be used to "guide" the user to all of the cells where they can enter data or make other changes.

To expand a little on wheat Gord Dibben said, all cells on a sheet are Locked by default initially. If you only want users to have access to a very few cells, then it's easy just to select those few and unlock them. But if you want only a few cells to be locked, then it's usually easier to start as he said - by unlocking them all and then going back and just locking the few that you need to be secure from change.

"Freddie Mac" wrote:

> I have a spreadsheet in which the user shall be able to change some cells
> completely, only change vaule in some (i.e. the cannot change formulas) and
> some cells that the user is unable to change at all. I have never undertood
> how you can do this in Excel, I know that there is some protection function
> but I have not had any sucess with that. Please help me if you know how! Any
> help is very much appreciated!
Received on Sat Jul 01 2006 - 08:10:01 PDT