Allowing changes to a protected worksheet
The Protect Sheet function is a handy tool which allows users to lock down a worksheet against editing. However, what if you have a data entry sheet where you want to allow users to edit some cells but leave other ones? Excel doesn’t make the process for this very clear, but it is actually a very simple process: