Login for excel Help Please!!

sqex

New Member
Joined
Nov 22, 2005
Messages
19
Hi Guys, im trying to create a login screen for an excel sheet, iv setup the first page with validation that links to sheet three to get its username as passwords


so its setup like this

Username :- Takes from the username list

Password :- Takes from the password list

Go :- want this when pressed to give access to the main sheet


But i dont want people to access the main sheet unless they have correctly enterd the correct user name and password any ideas on how to do this would be great still very new to excel..

Thanks in advance sqex. :)
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

atmospheric

Well-known Member
Joined
Jul 16, 2002
Messages
565
Is the username particularly important? If not, you can have excel open up and ask for a password before the sheet is visible:

Go to File > Save As, >Tools >General Options and you can enter a password to open, or a password to modify, click OK, enter the password again and Save.
 

sqex

New Member
Joined
Nov 22, 2005
Messages
19
Hi yeah, the username must be specific :/ as varsious users have access on differnt levels so a login page is a must.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,774
Members
412,482
Latest member
arooshrana2
Top