ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   lock of copy command (https://www.excelbanter.com/excel-worksheet-functions/226908-lock-copy-command.html)

manish

lock of copy command
 
how do i lock copy command in my excel sheet. i donot want anybody to copy
my data.
--
MIS EXECUTIVE
RKHS

Gord Dibben

lock of copy command
 
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

On Tue, 7 Apr 2009 00:29:01 -0700, MANISH
wrote:

how do i lock copy command in my excel sheet. i donot want anybody to copy
my data.



Paul

lock of copy command
 
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

"MANISH" wrote in message
...
how do i lock copy command in my excel sheet. i donot want anybody to
copy
my data.
--
MIS EXECUTIVE
RKHS





All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com