Hi sk

You can put macro code in the change event that changes this cell back to
what you want. Macros needs to be enabled though and you'll have to write
pretty good code.

HTH. Best wishes Harald


"Shinya Koizumi" skrev i melding
...
Without protecting sheet, is there any way to avoid
any input for a particular cell? I tried with the validation
,but I can still copy and paste on the cell.
I want to use this cell just for display

SK