Protect Cell Format But Allow Data Entry

[Skittle]

Is there a way of protecting a cell format in Excel ( eg. Number, text, general etc. ) but allowing an operator to enter a value in these cells?



Dazed and confused

 

[SkipVought]

Hi,

Check out Data>Validation.

Skip,

_[red][/red]

 

[GlennUK]

Skittle,

if you set the cell formats, and during formatting also format the Protection as having the Locked property unticked, then switch on protection for the sheet ( Tools/Protection/Protect Sheet ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.