I have two cells that, although locked on a protected sheet, can still be
deleted or altered. I can't figure out why. Each cell contains a formula
that calulates tax:
=IF($D$14="n/a","",$D$14*D16) where D14 is the subtotal and D16 is the tax.

All other cells in the sheet are protected properly. Can anyone help me
with this?

Which two cells contain the formulas and are you sure they are locked?

Are they really being deleted or do they look empty because D14 does = N/A?


Gord Dibben MS Excel MVP


On Wed, 21 Jan 2009 12:01:02 -0800, JSnow
wrote:

I have two cells that, although locked on a protected sheet, can still be
deleted or altered. I can't figure out why. Each cell contains a formula
that calulates tax:
=IF($D$14="n/a","",$D$14*D16) where D14 is the subtotal and D16 is the tax.

All other cells in the sheet are protected properly. Can anyone help me
with this?

The two cells that contain the formula are E16 and E17...
E16 formula: =IF($D$14="n/a","",$D$14*D16)
E17 formula: =IF($D$14="n/a","",$D$14*D17)

Yes, they're locked. I've quintuple checked that. :)

While the sheet is protected, I click on the cells (either one) and can hit
delete, or any key for that matter, and the cell contents change. This is
unique to those two cells, whereas all other locked cells bring up the "this
cell is locked" message.

JSnow

"Gord Dibben" wrote:

Which two cells contain the formulas and are you sure they are locked?

Are they really being deleted or do they look empty because D14 does = N/A?


Gord Dibben MS Excel MVP


On Wed, 21 Jan 2009 12:01:02 -0800, JSnow
wrote:

I have two cells that, although locked on a protected sheet, can still be
deleted or altered. I can't figure out why. Each cell contains a formula
that calulates tax:
=IF($D$14="n/a","",$D$14*D16) where D14 is the subtotal and D16 is the tax.

All other cells in the sheet are protected properly. Can anyone help me
with this?

If when protecting the sheet you disable(uncheck) "allow users to select
locked cells" can these two cells still be selected?


Gord

On Wed, 21 Jan 2009 15:11:01 -0800, JSnow
wrote:

The two cells that contain the formula are E16 and E17...
E16 formula: =IF($D$14="n/a","",$D$14*D16)
E17 formula: =IF($D$14="n/a","",$D$14*D17)

Yes, they're locked. I've quintuple checked that. :)

While the sheet is protected, I click on the cells (either one) and can hit
delete, or any key for that matter, and the cell contents change. This is
unique to those two cells, whereas all other locked cells bring up the "this
cell is locked" message.

JSnow

"Gord Dibben" wrote:

Which two cells contain the formulas and are you sure they are locked?

Are they really being deleted or do they look empty because D14 does = N/A?


Gord Dibben MS Excel MVP


On Wed, 21 Jan 2009 12:01:02 -0800, JSnow
wrote:

I have two cells that, although locked on a protected sheet, can still be
deleted or altered. I can't figure out why. Each cell contains a formula
that calulates tax:
=IF($D$14="n/a","",$D$14*D16) where D14 is the subtotal and D16 is the tax.

All other cells in the sheet are protected properly. Can anyone help me
with this?