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.

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.