Need a RESET button to clear parts of a form but not all of it.

[Tricks420]

Hello all,

I created a form for employees to fill out, then submit when done. It then emails the sheet to myself. I would like a "RESET FORM" button on the sheet that clears all the cells they just completed.

The form is Protected so users can't change titles or edit anything they are not supposed to.

The best solution I can think of is to clear data from unprotected cells, but I just can't seem to get it to work. I have tried multiple sources of code from the internet.

Here is the form Online Accountability.xlsm

Thanks in advance!

[jolivanes]

Which Cells need to be cleared?

[kasermap]

Should be simple. Change the range to whatever cells you need.

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

[Tricks420]

this worked, thank you!!

[jolivanes]

Thanks for the update and good luck.