The worksheet whose Options.Protected property is set to True prohibits content modifications of unlocked cells

When cells are specifically unlocked within a protected spreadsheet,  I would have expected them to behave at least within themselves exactly as if the sheet was not protected - and this expectation is pretty much realised within Excel.   However, although direct entry to a blank specific cell within an unlocked range is working out as I expect, other features such as deleting (clearing), pasting, or editing are either difficult or impossible.

I attach a zipfile containing some simple code which sets up a single column range of cells as specifically unprotected (not locked) and colours them yellow just to indicate easily which cells are unlocked.   As expected, without sheet protection, it makes no difference whether the cells are locked or not.   However, when protection is applied the differences between the locked and unlocked cells are not as marked as they should be.  Entries can be made only in the yellow range, but they can then be deleted or edited if the individual cells are put in edit mode.  If the popup menu is called within the unlocked range it can be seen that the only options available are "copy" and "format cells".  I can live without being able to merge cells in this situation but not being able to paste in a value (or values) and not being able to clear the content from the popup or by using the delete button (without having to go into edit mode) is very frustrating.  My poor guinea pig client who has just had her program "updated" is not very impressed.  (She is also not very impressed with the printouts either - as discussed separately.)