#1   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Harj
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Rogue Password on Properties and References ExcelMonkey Excel Discussion (Misc queries) 0 October 5th 05 01:16 PM
Password Issue keithl816 Excel Discussion (Misc queries) 6 July 10th 05 06:20 PM
Import Data Keeps asking for Password Dominator Excel Discussion (Misc queries) 0 June 5th 05 11:25 PM
Password cannot be removed twa14 Excel Discussion (Misc queries) 3 December 14th 04 11:27 AM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"