Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Rogue Password on Properties and References | Excel Discussion (Misc queries) | |||
Password Issue | Excel Discussion (Misc queries) | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Password cannot be removed | Excel Discussion (Misc queries) |