UTM Builder form in excel used by multiple teams in our department – The data entered is logged in a different sheet so I can’t protect the sheet as it will block the data submission. Essentially want to lock the form to other users when the first line of data has been entered into the form.

Tried protecting the sheet; messing around in the VBA but cannot get it working, can’t link to the submit or reset form button code. Not sure what code to use to lock the cell