password through a sheet

[golf32902]

I would like to have a sheet and in column A I would like it to show the users names, Column B Passwords, Column C and on to be the sheets. Using this sheet I would like to create a user name and password for a workbook and have it prompt me for the user and password but through the sheets above I would also like the user to have a visiblity to see other only the sheets that i allow them to see. The first sheet would be hidden to everyone else but me the Admin and just was wondering if there was a way to lock the enables macros so the user has no choise but to type in a user and a password.

Thanks for the Help everyone.

[Dököll]

I would like to have a sheet and in column A I would like it to show the users names, Column B Passwords, Column C and on to be the sheets. Using this sheet I would like to create a user name and password for a workbook and have it prompt me for the user and password but through the sheets above I would also like the user to have a visiblity to see other only the sheets that i allow them to see. The first sheet would be hidden to everyone else but me the Admin and just was wondering if there was a way to lock the enables macros so the user has no choise but to type in a user and a password.

Thanks for the Help everyone.

Hello, golf32902!

Are you hoping to have log in information stored in a spreadsheet and run VB code to prompt users for the information included, grant access to specific sheets?

http://www.oreilly.com/catalog/exceladn/toc.html

You'll need to do some digging, but this is quite fetching:-)

Please let us know if not helpful...

[golf32902]

Hello, golf32902!

Are you hoping to have log in information stored in a spreadsheet and run VB code to prompt users for the information included, grant access to specific sheets?

http://www.oreilly.com/catalog/exceladn/toc.html

You'll need to do some digging, but this is quite fetching:-)

Please let us know if not helpful...

Yes this is exactly what i would like to do. I just dont know how to create it. I just started to learn VB6 through VB for Dummies.

[Dököll]

Yes this is exactly what i would like to do. I just dont know how to create it. I just started to learn VB6 through VB for Dummies.

Good, go through the link I gave you, what you need is there, looks pretty basic..

[golf32902]

Good, go through the link I gave you, what you need is there, looks pretty basic..

will whit still work for version 2000?

[Dököll]

will whit still work for version 2000?

I imagine it should, it's only year younger than VB 6. Please let us know if up to snuff...

[golf32902]

I imagine it should, it's only year younger than VB 6. Please let us know if up to snuff...

I got this from ozgrid. I was wondering if you could show me how to make it have visiblity for sheets and if possible for cell visiblity too through the username and password sheet. thanks

[HTML]http://www.ozgrid.com/FreeDownloads/PasswordBook.zi p[/HTML]

[Dököll]

I got this from ozgrid. I was wondering if you could show me how to make it have visiblity for sheets and if possible for cell visiblity too through the username and password sheet. thanks

http://www.ozgrid.com/FreeDownloads/PasswordBook.zip

Greetings, golf32902!

I am not sure understand:

(1) You must unzip the file
(2) You'll need to use the default Username and Password

Are you saying this info is not visible to you?

[golf32902]

Greetings, golf32902!

I am not sure understand:

(1) You must unzip the file
(2) You'll need to use the default Username and Password

Are you saying this info is not visible to you?

It is visible I just wonted to show you the link to one that works for me. Thanks for your help.

[Dököll]

It is visible I just wonted to show you the link to one that works for me. Thanks for your help.

Sorry for the misunderstandin g, it is indeed very useful, and you're quite welcome:-)