Hi Mana

i dont know what you exacly mean with post the code in sheet module.?

The question is when i press f9 it still changes the value i want to lock this cellafter data entry. and when i push button then it calculates again. But nog when i click random cell or press f9. I hope you can help me with this

Thanks

Johan