Create multiple tab display based on unique password for users, while hiding tabs that do not pertain to them...

[themaster45]

I am hoping someone can help me.

What I am trying to do is the following.

I have a sales report for three sales people. I want it to be one file, but I would like it to only display the pages pertinant to the particular salesman, and not show the parts that do not pertain to him. What I am hoping I can somehow do is have the display be based on a password (actually three passwords). The password will be what indicates to excel which tabs to display, and keep the others hidden.

Mostly the issue is that I do not want Salesperson 1, seeing the tabs that pertain to sales person 2. It doesnt really matter how I acheive it, but that is my goal. Can anyone suggest anything?

Thanks!

 

[rguy84]

I don't think you can have multiple passwords unless you do a custom form. My gut says look into checking if the current user is ___, then show __ using windows auth.