Excel protection does not prevent users from copying data from protected sheets.It is not easy to prevent this but the code below will stop users from copying a range of data. It will not stop them from copying the data one cell at a time (a time-consuming process), but it is deterrant.If a user selects a range of cells then the macro will deselect the range and clear the clipboard of any copied information.Place this code in the corresponding VBA macro sheet.
', '