First off let me state that before this spreadsheet, I never used Macros whatsoever, so I’m completely new to it. I did use the “New to Excel” Sticky and a knowledgeable friend to get where I am now but have reached an impasse as to the why.

My first question is how do I change the coding to stop the following Visual Basic error when I click add – “Run-time error ‘1004’: The cell or chart that you are trying to change is protected and therefore read-only…”? I created a Macro that unlocks all affected sheets as a temporary workaround, but this UserForm will be for everyone to use where I work and I don’t want them using it.

My second question is how do I get the UserForm to actually enter data? I can use the form, but it doesn’t actually enter any data into my table (a little frustrating).

I’ve cut down everything to the objects, macros and sheets in question and attached it. Any help would be greatly appreciated at this point. Thank you all in advance.

UserThermalsForm.xlsm