Thread: Login Userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Moh Moh is offline
external usenet poster
 
Posts: 58
Default Login Userform

Hi
On a userform being used as a LogOn, I have two textboxes...txt1 & txt2. and
Commandbutton1 = Login Commandbutton2 = Quit.
The end user will use txt1 as a UserName entrance & txt2 as a PassWord
entrance. The enduser will use Commandbutton1 to Login once username and
password is correct. they will use Commandbutton2 to Quit the Workbook and it
should not give the user the option to Save before exiting at this point.

what code do i use to make this work?
so when the user types in the correct username and password - this data is
store in sheet4 - (column A = Username, column B = Password) it will open the
workbook.

if username or password is incorrect a message will appear saying "Please
check the username or password is correct"

Also the cross ( X ) button on the TOP RIGHT HAND CORNER of the userform
should be disabled - so it stops the user from clicking the X to enter.

Maximum users is 5

Can someone help with code and instruction where i need to input the codes?