Wrong line of code banned me out and can't access vba code...

Hello everybody.

I am not a very happy person at the moment.

I was playing with hide worksheet events so that I got my user login form popup and then after submiting correct credentials form would close and workbook would appear.

I don't know what line of code I changed or how but the impact is serious.

I belive that the workbook is not being opened as username and password can not be verified, comes up with incorrect username and passord.

The password is admin and password is wmex612.

Here's a copy of the file.

Any help will greatly improve my mood as at the moment I just want to kill myself.

Cheers,
Albert

If you don't enable the macros when you open the workbook, you can access the VBA Project ... so you can look at the current code.

And, if you select the View tab on the ribbon, you can unhide the workbook, so you can look at what you have in the sheets.


Regards, TMS

hi,
are you sure that is the username and the password? it looks like you wanna bypass the password...

Do the following in the immediate window so you can at least get at your code and try and fix what ever you did.

Please Login or Register  to view this content.

Include path in the open statement.

You might want to take out the Application.Quit command and instead simple close the workbook.

If it is not asking for macros to be enabled, Im guessing the file is in a trusted folder ... in which case, move it somewhere else. Or you're security setting is set to low ... in which case, move it up a notch or two so that you reject it.

Failing that, I could open the file and code so I can disable it and post it back.

Regards, TMS

tried holding down the shift key while opening the file?

See attached files.

I have changed the Workbook_Open to xWorkbook_Open so that it doesn't load the form.

You should now be able to see the code in both versions.

Regards, TMS

this line

Please Login or Register  to view this content.

is looking at column B for the password but you are matching the username against column F.