I know that you can create a login userform in excel but i was wondering if it is possible to set up a sheet which allows the user to login from. I have included my sheet which i would like the user to login with but not sure how or if it is possible to do so. If it is possible It would be great if someone could also tell me how it would need to be done. Thanks.
Last edited by mdovey; 12-06-2013 at 08:03 PM.
Login to what? What does the user have to login to be able to do/access?
Here is a skeleton based on your file that collects a userid and password but you will have to write the code to determine whether it's a valid combination. See module Login. The public variable LoggedIn can be called from any other module to determine whether a user has logged in. I used textboxes instead of cells so that it is easy to mask the password.
Last edited by 6StringJazzer; 12-06-2013 at 05:17 PM.
Sorry I haven't made it too clear as i have no idea how i would make a login on a sheet rather than a userform. I would like the user to enter in their username and password and if the input matches an existing account I want them to be taken to another sheets but if it is incorrect i want them to be denied of being redirected to this sheets and stuck on the login page until they enter a correct account or close the workbook all together. The username and password would be stored on another sheet in a table which would be checked once the enter button is pressed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks