lock of copy command

  • Thread starter Thread starter MANISH
  • Start date Start date
Not really possible in Excel.

You can protect the worksheet cells and not allow any cells to be selected
but I can override that by inserting a new worksheet or opening a new
workbook and linking to the cells on the protected sheet.


Gord Dibben MS Excel MVP
 
In our organisation, using Xl 2003, we password protect the sheets and
untick the select locked cells and select unlocked cells options.
This stops the "idiots" from copying but only for so long. For instance,
they can still print the details off and manually enter elsewhere.

Essentially don't allow them access to your workbook.

Paul
 
Back
Top