If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
prevent reading or any access to selected cells
Spreadsheet has personal data such as names, addresses. Also has Social
Security Numbers, which should be private. Trying to send the file to someone so they can edit part of the file. Don't want them even to see the SSNs. I know how to protect a cell from editing and how to hide columns, but can't figure how to allow editing but prevent even seeing the contents of certain cells. Am sure it's simple, but I'm stumped. |
#2
|
|||
|
|||
prevent reading or any access to selected cells
Excel's security isn't made to protect this kind of stuff.
If the recipient shouldn't see that info, then don't share the workbook with them. Maybe you can send them a unique id (not SSN, maybe name (first, last, mi)) and then you can use =vlookup() to retrieve what you need and put it into your workbook. R wrote: Spreadsheet has personal data such as names, addresses. Also has Social Security Numbers, which should be private. Trying to send the file to someone so they can edit part of the file. Don't want them even to see the SSNs. I know how to protect a cell from editing and how to hide columns, but can't figure how to allow editing but prevent even seeing the contents of certain cells. Am sure it's simple, but I'm stumped. -- Dave Peterson |
#3
|
|||
|
|||
prevent reading or any access to selected cells
Excel's internal security is very weak and passwords for protection are
easily cracked. The rule I and many others use is "If you don't want them to see it, don't include it in the workbook" Send them the parts of the workbook they are to edit. When they send it back, make changes to the one with the SSN's Gord Dibben MS Excel MVP On Wed, 26 Aug 2009 13:16:18 -0700, R wrote: Spreadsheet has personal data such as names, addresses. Also has Social Security Numbers, which should be private. Trying to send the file to someone so they can edit part of the file. Don't want them even to see the SSNs. I know how to protect a cell from editing and how to hide columns, but can't figure how to allow editing but prevent even seeing the contents of certain cells. Am sure it's simple, but I'm stumped. |
Thread Tools | |
Display Modes | |
|
|