User form read only question

Hi,

I'm working on a macro that has a user form to update a spread sheet. Is there a way to have the user form be able to be update the sheet but have the sheet read only? I want people to be able to enter data into the user form, have the user form update the sheet, but I don't want anyone being able to go back and manually change things on the sheet. Any thoughts?

Thank you in advance for you help.

Eddie.

Protect the sheet
Have the macro unprotect the sheet enter the data then re-protect the sheet

Thanks. I'll try that. I'll have to figure out to put in a loop I guess.

Eddie.