LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Login User Form

Hi
On a userform being used as a Login, I have two textboxes...txt1 & txt2. and
Commandbutton1 = Login Commandbutton2 = Cancel.
My staff member will use txt1 for the UserName & txt2 for the PassWord. The member of staff will use Commandbutton1 to Login once username and
password is correct from a sheet containing list of login details. 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?

When staff type in the correct username and password - this data is
store in sheet (master) - (column A = Username, column B = Password, column C = linked sheet) it will open the worksheet related to that un and pw.

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 15

I have used previous coding from this forum, but cannot seem to get it to work. If anyone can help me with this, it would be muchly appreciated. Can someone help with code and instruction where i need to input the codes?
 
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
How to automaticaly insert user name (login name) in excel? dheitz Excel Worksheet Functions 7 April 3rd 23 01:21 PM
making NT user/login user appear in a cell [email protected] Excel Worksheet Functions 1 March 3rd 09 03:41 AM
Open Specific Form by User Login Bowtie63 Excel Discussion (Misc queries) 1 November 30th 07 12:21 AM
Prompt user login when refresh data Terence Excel Programming 0 February 21st 05 03:10 AM
Shown Drop-down list if login user=C Albert Sim Excel Programming 3 January 20th 04 02:54 AM


All times are GMT +1. The time now is 10:46 AM.

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

About Us

"It's about Microsoft Excel"