how do i lock individual cells within a worksheet?
 

I used your instructions below but it removed the formating options for the
rest of the worksheet. This is important since I track changes in red font.
Is there anyway to protect a column of cells, per your instructions below
without the formating options for the rest of the worksheet going away?

"Earl Kiosterud" wrote:

Tony,

With the sheet not protected, use Format - Cells - Protection tab. Uncheck
"Locked" for those cells to be changeable. Now protect the sheet with
Tools - Protection - Protect sheet.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"CrazyTony" wrote in message
...
I am able to lock complete worksheets so that they can not be changed but
is
there any way that you can leave access to a certain amount of cells while
locking the rest, for example, those with formulas in them that react to
figures inserted by the user?

many thanks.

how do i lock individual cells within a worksheet?
 

When enabling the worksheet protection, checkmark allow users to format
cells.


Gord Dibben MS Excel MVP

On Fri, 20 Feb 2009 07:42:07 -0800, Janet
wrote:

I used your instructions below but it removed the formating options for the
rest of the worksheet. This is important since I track changes in red font.
Is there anyway to protect a column of cells, per your instructions below
without the formating options for the rest of the worksheet going away?

"Earl Kiosterud" wrote:

Tony,

With the sheet not protected, use Format - Cells - Protection tab. Uncheck
"Locked" for those cells to be changeable. Now protect the sheet with
Tools - Protection - Protect sheet.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"CrazyTony" wrote in message
...
I am able to lock complete worksheets so that they can not be changed but
is
there any way that you can leave access to a certain amount of cells while
locking the rest, for example, those with formulas in them that react to
figures inserted by the user?

many thanks.