I have made a macro which uses a user form, where you could type the Username and the Password. If either of them is wrong it gives the user two more chances to get them right until it closes the workbook, but not Excel itself. If he gets them right it opens your welcome page "Navigation", and closes the user form. I have one question: Is "Navigation" a html file in your computer or in the web, or is it another sheet in your Workbook?
Im a ALEVEL STUDENT WHO TOOK UP IT AND I NEED HELP!What i want is i want to create a login macro. what it is that my user will enter his login name and then his password allready set up on a page. he then has to click on the macro and the macro has to see if the login name and macro is correct. (I HAVE SET UP A USERNAME AND PASSWORD TABLE ON A ONTHER PAGE) If it correct then i want it to go to my welcome page called "NAVIGATION". if the user types either the username or password wrong then i want excel to save and shut down.
Can someone pls help me out on the coding for this or andy other way
Your help will be appriciated alot