How to make Team Members anonymous in an excel sheet

[Krust710]

Hi,

My aim is to have all of my team members putting their output on to one sheet. Which will pull all their performance reports in one place. However, I also need to make it so that they are anonymous in the spreadsheet so that they dont know who is who when they are in the sheet at the same time. Is there a way to either change the colleagues names to a number or make them all anonymous so that they dont know who is entering on the worksheet?

Any assistance would be appreciated.

 

[Micron]

Without knowing how many concurrent users you may have my suggestion may not be viable. What comes to mind is an encryption code that runs when they leave the cell where they just entered their name. It wouldn't be CIA level encryption but probably good enough to deter most users. If you have many concurrent users it may slow things down too much. Here's one page on the subject

How to Encrypt/Decrypt Selected Cells in Excel?

How to Encrypt Decrypt Selected Cells in Excel - Handling sensitive data safely is essential, and Excel has built-in tools that let you password-protect individual cells in your spreadsheets. You can protect sensitive data from unauthorised access or unintentional changes by encrypting and...

www.tutorialspoint.com