Hi,

I want to make a macro where a password has to be entered for the macro to work.
Each password would make available all individuals details of his/her contained in 4 separate worksheets.


There would be 9 different passwords (Individuals)
Macro works only if the password and individual match
Through each password, the data in the 4 sheets would get filtered to show only data relevant to that particular user.

For example:
when the individual and password match then 4 macros for each worksheet could be clicked

Please help.