Hello again,

My first post on this forum this morning was so successful I am going to try again with somthing perhaps a little more complicated.

What I am building is a form using Excel which will be completed by many users and for data integrity purposes I have to build in as many safeguards as possible to prevent "wrong" data being entered.

I have a few cells (J18:N18) which are auto populated if "VC" is entered into cell I18.

What I would like to do is lock these cells if VC is entered so that the data cannot be overwritten as long as VC is still in the cell I18.

If VC is removed from I18 then the data in cells J18:N18 will disappear because of the auto population formula I have in these cells and the cells should again be available for manual completion.

Can this be done? If so, be grateful for a suggestion as to the type of macro which would allow this to happen.

Thanks again