Different User Name password for one file

[atulexel79]

Hi All

I want to know how we can give different login username and password for one excel file

from that user can access specific sheets within that file which are allowed to that username
How can I do that?

Atul

[ANDREAAS]

Maybe you can build on the attached file by adding something like

Please Login or Register  to view this content.

and change the existing code to hide all shees at the workbook open event.

The "username" that i used in the top must be changed to our chosen username and A,C,D the sheets you choose for that user to be able to view.

hope this helps....

[atulexel79]

Thanks Sir

I appreciate your efforts and you have given me courage to do something extra ordinary.
But I am totally blind in VB coding
I have many sheets in my Workbook
And I want to give separate rights for different user
I like your user form very much
It is super duper for me which is very helpful and needful for me
But I am not getting Idea how to use it in my file

Request you please give me information step by step
So I can do it from my end

I have attached my file here

Eagerly Waiting for your reply

Atul

[atulexel79]

Dear ANDREAAS

I am still waiting for your reply

Atul