Hi all, I am new to excel vb and I am using a login and password form that I have downloaded for my workbook. It works perfectly until I click on Enter without any information entered in the user name or password boxes.
It then gives me a run time 1004 error which means the instruction on what to do in such an event has not been taken into account.
It also opens the workbook without the user name or password having been entered which defeats the whole object. Is there anyone with an idea of how I could handle this please ? I am getting desperate and to the point where climbing the walls seems quite attractive.
Thank you in advance.
It then gives me a run time 1004 error which means the instruction on what to do in such an event has not been taken into account.
It also opens the workbook without the user name or password having been entered which defeats the whole object. Is there anyone with an idea of how I could handle this please ? I am getting desperate and to the point where climbing the walls seems quite attractive.
Thank you in advance.