InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Microsoft Excel 2000 - Prevent Copy? |
| Answer» <html><body><p>Is there any way to prevent a user from copying an entire worksheet and <a href="https://interviewquestions.tuteehub.com/tag/pasting-1148788" style="font-weight:bold;" target="_blank" title="Click to know more about PASTING">PASTING</a> it in a different file?<br/>Thank you!You can always apply protection on your <a href="https://interviewquestions.tuteehub.com/tag/worksheets-1460150" style="font-weight:bold;" target="_blank" title="Click to know more about WORKSHEETS">WORKSHEETS</a> and workbooks.<br/><br/>Tools -&<a href="https://interviewquestions.tuteehub.com/tag/gt-249387" style="font-weight:bold;" target="_blank" title="Click to know more about GT">GT</a>; 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. <br/><br/>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</p><blockquote>Is there any way to prevent a user from copying an entire worksheet and pasting it in a different file?</blockquote>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 <a href="https://interviewquestions.tuteehub.com/tag/tried-7272297" style="font-weight:bold;" target="_blank" title="Click to know more about TRIED">TRIED</a> 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 <a href="https://interviewquestions.tuteehub.com/tag/actual-361632" style="font-weight:bold;" target="_blank" title="Click to know more about ACTUAL">ACTUAL</a> 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 <em>do</em>...</body></html> | |