Electronic signing for an Excel Spreadsheet

L

Lee Bob

I have developed a form which will be completed by one person then forwarded
to a second person (Supervisor) who needs to approve it then it needs to be
forwarded to me for final action. It is a payroll form so I need to ensure
the proper supervisor has seen and approved the form and no one else has
forwarded it to me (i.e. the employee). There are about 160 employees and
probably 15-20 supervisors. Any ideas would be appreciated.
 
C

chris100

Hi Lee Bob,

You could provide the supervisors with unique passwords which they can
then "sign" the work off with. I suggest passwords because this way you
know that when you forward to someone that even if someone acceses it
only the supervisor with the correct password can sign off.
I was thinking about this myself but aren't good enough at VBA to
write the code for it. It my case users have to sign off for goods
received. If you search for user entry forms in excel programming you
might find something similar.

Let us know if you find anything.

Chris
 
Top