Format cells macro

[andrewhoddie]

Hello again

I currently have a macro that when you click save on the user form populated the next empty row on a different worksheet within the same work book.

I would like to know is there a way of then locking these cells immidiately so they can not be changed?

locking them in advance causes an error with the population of the sheet and the user needs to be able to enter data into the sheet. for example A:K is locked when data is added to the row but L: onwards is unlocked

thanks in advance