Password
 

Hi, I'm doing a project for college and what I'm tyring to do is customise a
password.

I've got a Home Page in Excel and a button that says "Click Here To Enter"
and when they click I want a dialogue box to come up and say:

Staff ID:
Password:

And id they enter a correct ID and Password then they can enter the site. I
don;t know how to o this though, I know how to password protect sheets but I
want this really specific!

Any help would be greatly appriciated!

Thanks
Laura
xxx

Password
 

You can't use different passwords for protecteting the same sheet. You may
want to use VBA code & user forms to prompt for staf id and password then
compare the two before allowing access.
Regards

"Laura" wrote:

Hi, I'm doing a project for college and what I'm tyring to do is customise a
password.

I've got a Home Page in Excel and a button that says "Click Here To Enter"
and when they click I want a dialogue box to come up and say:

Staff ID:
Password:

And id they enter a correct ID and Password then they can enter the site. I
don;t know how to o this though, I know how to password protect sheets but I
want this really specific!

Any help would be greatly appriciated!

Thanks
Laura
xxx