I have a workbook that a group of people need to update. I have been
unlocking the cells I want updated and protecting the worksheet. This allows
one user at a time to access. I was told that I could share and protect the
workbook so that users could update simultaneously. I noticed however that
in the share and protect mode, the protection feature no longer worked and
users could change data in cells that are locked. How do I share the
workbook and protect the locked cells from changes?