UsefulGyaan Has Posted the Following On 07-24-2013 10:15 AM:

We protect a worksheet so that it can not be modified and this protection applies to VBA operations and user actions both. Some VBA operations like pasting data cannot be done on a protected worksheet. Now to perform these operations on that sheet we need to unprotect it, do the operations and then protect it […]

VBA Trick of the Week:: Protect Worksheet for User Actions Only