multiple security on spreadsheet

[leem]

Good morning,
I'm stumped and so out of my realm here but looked at like I should be able to figure this out.... I appreciate any help/direction that you can give me.

I have been asked to take a report that is done weekly and make it secure. NOt with just 1 password but to be able to give multiple passwords so that no one can see what does not pertain to them. I have a file that maintains hours. I need to set up a password for each of our locations and password on that location, then report would only show that locations information.

This is what I envision but I could be directed in another direction:

Person A clicks to open the spreadsheet - sample attached
they are prompted to enter the location - (see location listing on attachment)
they are then prompted for a password for that location
spreadsheet would open and only show that location for each tab

Is this even possible? I really thank you in advance for your expert knowledge.
Michelle

[Kyle123]

Not reliably. Excel security is beyond rubbish, anything you put in place can be easily bypassed.

You'd be better off creating separate workbooks.

[leem]

Thank you. I was really hoping that would not be your answer...80 some different workbooks. Here's a thought... I can limit who has access to it so what about the prompt for what svc and only that svc information is showing. For instance a pop up for which svc - enter CLT and only the CLT information shows on each tab. All other rows deleted.

Should I close this one and open a differnt post.

Thanks
Michelle

[Kyle123]

If the user disables macros, unfortunately they'd be able to see everything