Protecting columns in a table, without protecting the sheet

[Kelli Webb]

Hi,

I've created a table that has formulas that I would like to protect.

I have found a workaround by using Data Validation to stop anyone from overwriting the result, but this does not stop them from deleting it.

Does anyone know how I could get around this without protecting the sheet? Because we all know the table doesn't function as it should once protected.

Thanking you in advance for your assis

 

[vletm]

Kelli Webb
Did You tried this kind of validation? ... for Source, set something 'not normal'.

 

[Kelli Webb]

Kelli Webb
Did You tried this kind of validation? ... for Source, set something 'not normal'.
View attachment 62910

Hi Vletm, I've tried >0 and formulas but it doesn't stop them from being able to delete the formula/result.
Kelli

 

[vletm]

Kelli Webb
Did You tried as I gave a hint?
Did You watch that snapshot?
... List
... for 'Source' ... something 'not normal'
and unselect those two?