protecting formula in cell?

I have a spreadsheet the has a 'dummy' row at the top that contains some blank cells and some cells with formulas.
I have a macro that copies this row and adds it underneath to make new rows that of course, contain the formulas.
Unfortunately when the user then fills in the rows they sometimes make a mistake and then go back and delete information from a cell and then the formula is gone. Is there a way to 'protect' the formula so that it can be copied and pasted by the the macro but not deleted by the user?

To add CODE tags, select your code and then click the # icon above the edit window. Do not actually type # into your post.

Or simply type in the tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

6stringjazzer,
Thanks so much for the reply. So.....I'm a real beginner and self taught myself macros through YouTubes and with assistance from some great responders here.

So having said that....I'm not sure how to lock cells and protect sheets but I'm sure I can figure it out. Fixing the code is anothe story.

I'm going to put the code below and maybe you can show me how to unprotect and reprotect the SOLD sheet in the code? (I call the macro with a 'button' titled UPDATE from the ITEMS sheet. It then moves items from the ITEMS sheet to the SOLD sheet by copying the dummy row at the top of the SOLD sheet and inserting the data from the ITEMS sheet.

Here's what the macro code looks like.....

Please Login or Register  to view this content.

Thanks!