LOGIN ID AND PASSWORD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SANDIND - 31 Jul 2008 18:01 GMT

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

Reply to this Message

RyanH - 31 Jul 2008 18:14 GMT

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!

Signature

Cheers,
Ryan

> Hi,
>
[quoted text clipped - 5 lines]
>
> SS

Reply to this Message

SANDIND - 31 Jul 2008 18:31 GMT

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.!!

> 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
[quoted text clipped - 14 lines]
> >
> > SS

Reply to this Message

RyanH - 31 Jul 2008 19:05 GMT

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?

Signature

Cheers,
Ryan

> Thanks RyanH for your quick response.
>
[quoted text clipped - 29 lines]
> > >
> > > SS

Reply to this Message

SANDIND - 31 Jul 2008 19:46 GMT

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

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

SS

> Unfortunately, I'm still not clear what you are asking. Are you wanting this:
>
[quoted text clipped - 38 lines]
> > > >
> > > > SS

Reply to this Message