Creating a log in screen with user name and password

I need to create a log in screen in excel with a user name and password, ideally, there will be 2 users, the main operatives and the admin. They both will have different privleages.

how can this be done??

thansk very much

jd

I need to create a log in screen in excel with a user name and password, ideally, there will be 2 users, the main operatives and the admin. They both will have different privleages.

how can this be done??

thansk very much

jd

Originally Posted by dominicb

Good morning jermaindefoe

OK, I see three possible explanations here :
(i) You are a famous footballer (called Jermain Defoe)
(ii) You are a Spurs fan (not called Jermain Defoe)
(iii) You really are called Jermain Defoe (and nothing to do with the footballer or Spurs)

On to your question. I have a template available that allows an administrator to set user priveliges and determine which users can access (read-only or read write) which sheets. You as administrator can see all sheets. Each user wil be required to enter a username and password before they can use the workbook.

If this sounds like something you (or anyone else) can use, then PM me your e-mail address and I'll forward it on to you.

HTH

DominicB

ive pm'd you