Using VBA to login to workbook

[johnpants]

Hi, I have a workbook 'Admin' that is protected by a userform login with 1 username, and 1 password. The problem is that this workbook contains the multiple usernames and passwords that are required to access a seperate workbook 'Data Entry'. Is there anyway I can add some code that will effectively login to the Admin workbook so the Data entry workbook can verify the username and password details?

Thanks,

John.