Yes

You need to have an auto_open macro that opens a form for the user to enter
their name and password. You then check the name and password and if the name
and password agree then you can allow access.

You need to set all the sheets visibility to very hidden and you do that in
VB project exlorer except for one sheet that is a splash type screen. You
then password protect the vba project and then you save the work book hiding
all the sheets except 1.

You also have an auto_save and auto_close macro that saves the workbook
hiding the worksheets (for the save one you need to unhide the sheets
aft5erwards).


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


" wrote:

Hello fellow programmers!

I was woundering if any one knew some code to allow me to do the
following...

I have 10 employees with 10 unique user names and 10 unique
passwords...

I have all 10 employees listed in Column A and all the passwords listed
in Column B, so I am wondering is it possible to create a UserForm to
allow a person to enter the user name and password to gain access to
workbook if it matches correctly to their name and password off the
values on the spreadsheet? Any help is greatly appreciated!!!