Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent copy and pasting into a selected range of a works | Excel Discussion (Misc queries) | |||
Prevent Access To already open file | New Users to Excel | |||
Excel should enlarge the current selected row for easy reading | Excel Worksheet Functions | |||
Prevent new pivot table items from being selected | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) |