Hello everyone,
I need your help with my application:
• Three inspectors to inspect various parts. Each part has its own inspection record file (“Inspection record” workbook). Say I will have 500 of these inspection files.
• When an inspector completes his inspection, he is supposed to sign his name on the inspection record file and export that to PDF (see “Inspection record” workbook – cell C6). Password match name can the name would display
• Currently I have hardcoded in each inspector’s password in a private sub on Sheet 1 of “Inspection record” workbook.
I’m not VBA programmer but I was able to search online a come up with a solution for my application, however it is half-way done. Say if one of current inspector quits his job, then I have to change all the hardcoded modules already built into my inspection record files.
Question: I think there must be a way to store a list of inspectors and their password in a separate file/module (e.g. on a separate “Password” workbook) then all the 500 inspection record files can refer back to that inspector list for password and name verification.
I would appreciate all your help. Thanks and have a good day.
Additional info:
C6 on "Inspection record" is a name but it requires a password to enter. Says Alan chooses his name from the dropdown list, then enter his password. if password is not correct, then there will be an error message box display and the C6 cell turns blank - i.e. name and password must match to turn C6 cell on. otherwise it is blank
However, the password and list of names are "hard-coded" into the Sheet1 of "Inspection record" workbook. This is hard coded, so I want to have my "Inspection record" check "Password" workbook for list of names and corresponding passwords. so if a person quits, then I will not have to edit all the inspection files. Instead I will only need to edit "Password" workbook. Hope it makes senses.
Bookmarks