how do I lock formulas, but I can still delete data?
 

I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?

Thanks

Dave

Two ways

1) If it's just for you go to EditGo toSpecial... and select 'Constants'
and/or numbers and text and pres the delete key
2) For all users, select all the cells you want to delete. (You might do
this by method 1) and then go to FormatCellsProtection and un-check
locked. Now go to ToolsProtectionProtect sheet... and you will now only be
able to delete the cells you want deleted.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dave" wrote in message
...
I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?

Thanks

Dave

EditGo To(or F5)SpecialConstants. Tickmark what you want selected then OK
your way out.

EditDelete what is highlighted.

Gord Dibben Excel MVP

On Sat, 1 Jan 2005 20:15:03 -0800, "Dave"
wrote:

I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?

Thanks