VBA to require password to filter

[gmittar]

Hi All,

I have a simple sheet of names and roles that I need to send out to about 60 different people. The sheet has all data filtered out, and the recipient selects their organization from a drop down filter, which shows their portion of the sheet. This all works well as is.

What I would like to do is to protect the sheet so that when they select an org from the dropdown, they are prompted for a password. Further, I would like this password to be unique to their org. So I'd like to have a list of orgs and their corresponding passwords that I will superhide. So, select Org #16 , require password #16 .

Any ideas about how to accomplish this?

Thank you in advance

 

[mumps]

My pleasure.

 

[Kyle123]

As a word if advice, all macro based security is trivial to remove. In the simplest case, all the user need do is disable macros.

In a nutshell, if you actually need security/it's important that people cannot see the data, you either need to remove it before sending or find a tool that isn't excel to do the job.