Hello - We have an 18000 entry worksheet which we have had to check every entry by eye recently to ensure validity. We do not want to have to do this exercise again. I know you can lock a worksheet so it is read-only however we need to be able to keep adding entries to the worksheet. Is it possible to make a section of a worksheet read-only? We are using Excel 2007.

Also, we would like to use this worksheet to import data into an Access database. If we make a section of the worksheet read-only will this prevent the data being imported into Access?

Thank you for your help.