Thread: Hiding Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Hiding Data

It's possible for naive users, but I would strongly advise against it.
Even naive users who can find these newsgroups can find ways to bypass
any internal protection in a heartbeat.



In article ,
Excel Help! wrote:

I created a spreadsheet that I want to share. It allows users to enter
personal data. Is it possible that a user can enter their data and not be
able to view all of the data of another person? Example: The user can enter
data in the next available row (all required data), but can't view the SSN of
user 1? Thanks for any help.

User 1 -Roll 1: Name; Address: SSN
User 2 -Roll 2: