I need a userform front end to open up only (end user not to see back end data worksheet in excel)...the excel workbook is to be used by several people at the same time....if this can be done in 2007...
so when the user clicks the excel 2007 file from their desktop the workbook opens with userform, no worksheets visible - the resource then types in customer account number in first field and the result is displayed in the second field. ..
userform to have close and save userform/workbook button..to close down workbook...
so spreadsheet 1
column A. column B.
Account Number. Organisation Name
4677883. Bank of New York
in total I have 450,000 rows of data....