Hello,

Can anyone help I have created a excel spreadsheet where by different users can add information into a spreadsheet through a user form.

The information is then displayed a sheet within the workbook.

By only problem is that some users are going in and messing with the data, is there anyway I can make it read only with out it affecting inputting data.

i tried making the sheet read only put the userform comes up with an error.

Thanks

Mel