Forum Discussion
Lock some cells for editing at the same time lock another range from pasting
Cherry1313 By default, all cells on a sheet are locked (check this by right-clicking and selecting Cell Properties, locked tab). But the lock is only activated when you protect the worksheet (Review, Protect sheet). It is there where you define what is allowed and what is not allowed.
You cannot disallow pasting using these options. Fortunately, with the latest builds of Excel, protecting a worksheet als protects it against loosing your data validation when the user pastes. But they can still paste invalid values I'm afraid.
Thank you for the insight.
You are right I could not find a way to do it using locking and protecting.
VBA provides a work around but unfortunately VBA would need a user to first allow macro runs which in our shared file scenario case cannot be enforced.
