Using e-signatures or series of passwords pulled from another workbook for ops and quality approvals? Help!

[phatphil3c]

Hi Everyone!

I have been creating an excel file that is a maintenance request form. Each tab is a separate vba form that tracks the various steps of the process (tab 1 = maint request by operators, tab 2 = actual work done by maintenance, tab 3 = quality checks info and pass/fail, etc). With help from this site, I have been able to figure out how to search for the correct job number and add new info to the same row (thanks Dave dmt32!!!) as each step is completed. This is my first project so I have no experience but find it a lot of fun to try things out and see something actually work!

Now I'm faced with a new challenge: the finished work needs final approvals from authorized quality and operations employees. Due to FDA and ISO regulations, the info for the approvals has to be protected information. One acceptable way would be to incorporate e-signatures. But is it possible to add an e-signature to cells within a row using vba code, and then have 1000 lines with e-signatures on them?

I was thinking maybe there's a different way to do it too? I could make 3 text boxes (1 for username and 2 for separate passwords), where it will reject/ won't submit if not all 3 boxes match the criteria (each person would need their own unique ID and passwords). However, that info would also have to be stored in a separate workbook that's protected so no one has access to the passwords (no idea how to reference a different workbook either).

Does anyone have any suggestions on how to accomplish this? Any help would be greatly appreciated!!

Thanks!
Phil

 

[lizemi]

Hi have you had any success in getting code? It seems like exactly what I been looking for

 

[phatphil3c]

Hi lizemi. Unfortunately no. No one has given me a response. I had to put the project on hold and move on. I hope this gets answered as we have no budget and I have multiple forms prepped and ready for this last step.