Dear All,

I am trying to build an Excel file for a sales reporting purpose. I am using Excel 2010 and I would like that each of the 13 different users of this file can enter it using a unique password and a unique username assigned to them, preferably Windows log in credentials.

Also, most importantly, I want each user to see only their territory on each sheet, so they can only see a designated range. I am using drop down lists to customize the visualization of the KPIs for each user.

Is there a way to program Excel so that when a user opens the file, they type their username and password and eventually they can only select their respective region from the drop down list and see only their sales teams performance?

Thank you very much for your help in advance,

Gergo