Restrict Manual Editing of Spreadsheet

Hello everyone!

My problem--- for work I have created a macro that basically creates a database in excel, and makes recommendations and calculations based on that database.

I've created several UserForms that retrieve the data to be stored, and then stores and edits it in the spreadsheets.

What I need now is a way to make sure that people cannot go in and manually change data in the spreadsheet. I only want them to be able to edit the spreadsheet through the macro. Is there a way to do this? I tried just protecting the sheets, but doing that also restricts the macro from being able to edit.

Thank you for your help!

jaslake,


Thank you!

Worked beautifully!