Solve : Microsoft Excel 2000 - Prevent Copy?

1.	Solve : Microsoft Excel 2000 - Prevent Copy?
Answer» Is there any way to prevent a user from copying an entire worksheet and PASTING it in a different file? Thank you!You can always apply protection on your WORKSHEETS and workbooks. Tools -&GT; Protection -> Protect Sheet / Protect WorkbookTools -> Protection -> Protect Sheet / Protect Workbook will not prevent copying and pasting into another file. It will only prevent the specific file in which protection was enabled from being modified. You may want to put a password on the file to open or modifiy it. To do this, use Save As, and click on Tools in the Save As panel. Then, choose General Options and set the password(s).Quote Is there any way to prevent a user from copying an entire worksheet and pasting it in a different file? Convert it to a PDF; don't distribute the xls file. You can do this using the free program, PrimoPDF. Find a link to it in the software FAQ (see my signature).I never TRIED it with a PDF of an Excel sheet, but it is possible to copy text from a PDF quite easily - just nobody knows about it I can't recall seeing a PDF of a spreadsheet but I'm sure that it would not contain formulas. It would simply show the results of formulas, just as the ACTUAL spreadsheet would. So, even though the numbers and text in an Excel file converted to PDF could perhaps be copied, the underlying formulas could not. Good point.I guess it would be useful to know what the OP actually wants to do...

Answer»

Is there any way to prevent a user from copying an entire worksheet and PASTING it in a different file?
Thank you!You can always apply protection on your WORKSHEETS and workbooks.

Tools -&GT; Protection -> Protect Sheet / Protect WorkbookTools -> Protection -> Protect Sheet / Protect Workbook will not prevent copying and pasting into another file. It will only prevent the specific file in which protection was enabled from being modified.

You may want to put a password on the file to open or modifiy it. To do this, use Save As, and click on Tools in the Save As panel. Then, choose General Options and set the password(s).Quote

Is there any way to prevent a user from copying an entire worksheet and pasting it in a different file?

Convert it to a PDF; don't distribute the xls file. You can do this using the free program, PrimoPDF. Find a link to it in the software FAQ (see my signature).I never TRIED it with a PDF of an Excel sheet, but it is possible to copy text from a PDF quite easily - just nobody knows about it I can't recall seeing a PDF of a spreadsheet but I'm sure that it would not contain formulas. It would simply show the results of formulas, just as the ACTUAL spreadsheet would. So, even though the numbers and text in an Excel file converted to PDF could perhaps be copied, the underlying formulas could not. Good point.I guess it would be useful to know what the OP actually wants to do...

Solve : Microsoft Excel 2000 - Prevent Copy?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment