Hi,

I want to create Login id and password for individuals opening the sheet. I
want id and password to be picked from any other workbook or even from one of
the sheets/tabs of the same workbook.

Thanks for your help in advance.

SS

I use a UserForm for this. In the Userform you would have a ComboBox with
all your Users in it, and a textbox for the password along with labels and a
Ok and Cancel Button. I would then load the USerform in the Workbook_Open
Event.

I'm not sure what your second sentence means. Can you specify more?

Hope this helps!
--
Cheers,
Ryan


"SANDIND" wrote:

Hi,

I want to create Login id and password for individuals opening the sheet. I
want id and password to be picked from any other workbook or even from one of
the sheets/tabs of the same workbook.

Thanks for your help in advance.

SS

Thanks RyanH for your quick response.

In the second sentence I meant that will it possible for me to give ID and
password in another sheet so that once Id and password are entered in combo
box then same can be verified/ matched with the id and password in another
sheet/tab.

In your case how you define password for each individual and how they are
verified.

Can you please if possible write the code for me,which you feel will work
good for me. Thanks for all your help.

Have a great day.!!

"RyanH" wrote:

I use a UserForm for this. In the Userform you would have a ComboBox with
all your Users in it, and a textbox for the password along with labels and a
Ok and Cancel Button. I would then load the USerform in the Workbook_Open
Event.

I'm not sure what your second sentence means. Can you specify more?

Hope this helps!
--
Cheers,
Ryan


"SANDIND" wrote:

Hi,

I want to create Login id and password for individuals opening the sheet. I
want id and password to be picked from any other workbook or even from one of
the sheets/tabs of the same workbook.

Thanks for your help in advance.

SS

Unfortunately, I'm still not clear what you are asking. Are you wanting this:

User Opens the Workbook.
The user enters Username and Password.
Then depending on who signs in you want to give them access to only certain
sheets in the Workbook.

Right?
--
Cheers,
Ryan


"SANDIND" wrote:

Thanks RyanH for your quick response.

In the second sentence I meant that will it possible for me to give ID and
password in another sheet so that once Id and password are entered in combo
box then same can be verified/ matched with the id and password in another
sheet/tab.

In your case how you define password for each individual and how they are
verified.

Can you please if possible write the code for me,which you feel will work
good for me. Thanks for all your help.

Have a great day.!!

"RyanH" wrote:

I use a UserForm for this. In the Userform you would have a ComboBox with
all your Users in it, and a textbox for the password along with labels and a
Ok and Cancel Button. I would then load the USerform in the Workbook_Open
Event.

I'm not sure what your second sentence means. Can you specify more?

Hope this helps!
--
Cheers,
Ryan


"SANDIND" wrote:

Hi,

I want to create Login id and password for individuals opening the sheet. I
want id and password to be picked from any other workbook or even from one of
the sheets/tabs of the same workbook.

Thanks for your help in advance.

SS

Yes RyanH, You are correct you understood the same correctly...

Sorry for the confusion....Can you help me out ....thanks in advance !!!

SS

"RyanH" wrote:

Unfortunately, I'm still not clear what you are asking. Are you wanting this:

User Opens the Workbook.
The user enters Username and Password.
Then depending on who signs in you want to give them access to only certain
sheets in the Workbook.

Right?
--
Cheers,
Ryan


"SANDIND" wrote:

Thanks RyanH for your quick response.

In the second sentence I meant that will it possible for me to give ID and
password in another sheet so that once Id and password are entered in combo
box then same can be verified/ matched with the id and password in another
sheet/tab.

In your case how you define password for each individual and how they are
verified.

Can you please if possible write the code for me,which you feel will work
good for me. Thanks for all your help.

Have a great day.!!

"RyanH" wrote:

I use a UserForm for this. In the Userform you would have a ComboBox with
all your Users in it, and a textbox for the password along with labels and a
Ok and Cancel Button. I would then load the USerform in the Workbook_Open
Event.

I'm not sure what your second sentence means. Can you specify more?

Hope this helps!
--
Cheers,
Ryan


"SANDIND" wrote:

Hi,

I want to create Login id and password for individuals opening the sheet. I
want id and password to be picked from any other workbook or even from one of
the sheets/tabs of the same workbook.

Thanks for your help in advance.

SS