VBA to Create Signature on Worksheet

Greetings,

Background: The Accounting Manager at my job has 3 workbooks with about 24 worksheets on each workbook. He wants to keep only these three workbooks, but has an accounting team working on different sheets in each workbook. He would like a signature in each worksheet recording the person's name, a timestamp indicating when they completed the project, and (preferably) protecting the worksheet so he will know to review the worksheet. Basically he wants the signature line aspects of a workbook, but for a worksheet instead of a workbook. I mentioned the idea of separating the worksheets into separate workbooks, but he doesn't want to do this as it is hard enough for him to track the 3 workbooks.


Questions:

1. Does anyone know of a way to add the signature line feature of excel to a worksheet instead of the whole workbook?
2. If not and I need to start from scratch, would this be easiest to do using UserForms? If so, do you have any suggestions on how to proceed from here?

Thanks in Advance!

.
Would having a 'tracker sheet' work ?

- This sheet is hidden

- The sheet tracks the Date / Time / Specific Cell Edited / User Computer Name Doing The Edit / What Edit Was Performed


???

answer logit and if no, i can whip something for you.

Originally Posted by Logit

.
Would having a 'tracker sheet' work ?

- This sheet is hidden

- The sheet tracks the Date / Time / Specific Cell Edited / User Computer Name Doing The Edit / What Edit Was Performed


???

Thanks for the thought. The manager already uses Microsoft Projects for tracking purposes, so he doesn’t want a second tracking sheet. He just wants something simple on the actually sheet that captures the data mentioned in the OP (signature of user, timestamp, and sheet protected with a simple password so those on team will know to leave it alone until reviewed).

Ok ......................