I have a shared worksheet - customer service reps add information to it using a user form; analysts work the issues directly on the spreadsheet. I have had a problem lately where the customer service reps are bypassing the user form and entering data directly on the spreadsheet - this is not good, because my form is set with all sorts of validation and required fields and such. Would there be a way, in a shared spreadsheet, that we can restrict all of the users from entering data directly onto the spreadsheet, yet still allow the analysts access to work it?

Thanks in advance