| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Worksheet from Copy Past
Hello,
I am using Excel 2000. I also have some delicate files which I have protected the sheets and workbook. In these protected sheets I have some hidden rows / columns but I notice I can; select all/copy/past to a new workbook, and this will reveal ALL the hidden information. Q: How can I protect a worksheet / workbook from being copy and pasted to a new worksheet to reveal it's hidden information? -- Thank you, Trying Hard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect Worksheet from Copy Past
You cannot. There is no "real" security. If you don't want someone to see
the information, remove it before you send the workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Trying Hard" wrote in message ... Hello, I am using Excel 2000. I also have some delicate files which I have protected the sheets and workbook. In these protected sheets I have some hidden rows / columns but I notice I can; select all/copy/past to a new workbook, and this will reveal ALL the hidden information. Q: How can I protect a worksheet / workbook from being copy and pasted to a new worksheet to reveal it's hidden information? -- Thank you, Trying Hard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect Worksheet from Copy Past
Anne,
I actually linked the pertinent information to another page/hid the linked page/and protect the workbook; this works for me :?) I do appreciate your quick reply -- Thank you, Trying Hard "Anne Troy" wrote: You cannot. There is no "real" security. If you don't want someone to see the information, remove it before you send the workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Trying Hard" wrote in message ... Hello, I am using Excel 2000. I also have some delicate files which I have protected the sheets and workbook. In these protected sheets I have some hidden rows / columns but I notice I can; select all/copy/past to a new workbook, and this will reveal ALL the hidden information. Q: How can I protect a worksheet / workbook from being copy and pasted to a new worksheet to reveal it's hidden information? -- Thank you, Trying Hard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect Worksheet from Copy Past
There are many ways to hack a protected worksheet or workbook.
I would NEVER send confidential information. Better that you should develop a way to take the needed data and transfer it to a new workbook and send ONLY that data. Otherwise, you are assuming your users are either technically illiterate or that they don't own password-cracking software. Just be careful. :) ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Trying Hard" wrote in message ... Anne, I actually linked the pertinent information to another page/hid the linked page/and protect the workbook; this works for me :?) I do appreciate your quick reply -- Thank you, Trying Hard "Anne Troy" wrote: You cannot. There is no "real" security. If you don't want someone to see the information, remove it before you send the workbook. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Trying Hard" wrote in message ... Hello, I am using Excel 2000. I also have some delicate files which I have protected the sheets and workbook. In these protected sheets I have some hidden rows / columns but I notice I can; select all/copy/past to a new workbook, and this will reveal ALL the hidden information. Q: How can I protect a worksheet / workbook from being copy and pasted to a new worksheet to reveal it's hidden information? -- Thank you, Trying Hard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
| How Do I Protect A Worksheet But Allow Copying Columns | Excel Discussion (Misc queries) | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| Is there a function to copy an entire worksheet? | Excel Worksheet Functions | |||
| copy link from next worksheet | Excel Worksheet Functions | |||
Linear Mode
