assign various password for different view of information in excel

[WCGK]

Hi,
Can anyone help me with below?
I am trying to have 3 passwords for 3 different users to view different set of data in my report.

I have an access page. This access page consists of person's name A,B &C.
Once person A log in with password A, excel will display an index1 page with 5 item.


If person B log in with password B, excel will display an index2 page with only 4 item and only data B is display.

If person C log in with password C, excel will display an index2 page with only 4 item and only data C is display.

I have created a few VBA codes. However, i do not know how to link them all together.. I have no problem with person A log in.. However, person B & C is sharing the same index page & data page .. I am not sure how i can link multiple VBA module to one button.


Can anyone please kindly help me?
Thanks in advance.

 

[sijpie]

The easiest is to have two seperate sheets for B & C. You can copy the existing sheet and then modify it.

 

[WCGK]

Hi,

Thanks for your suggestion... =)
Hm.. but my report does not only cater for 3 person.. i need to have up to 17 different password..

Is that possible?

 

[sijpie]

A lot is possible, and there are various options:

• For each user a viewsheet is created, linking the data to the master data sheet(s). All sheets are hidden, except for the one unlocked for the user.
• The viewsheet is created 'on the fly' when the user logs in, using VBA to copy the relevant ranges on to the viewsheet.

you pick the method you find easiest to manage.