How to create separate signature lines on separate sheets?

[tdoen]

Hi all,

I have inherited an Excel-based project that I would like some help with. I need to be able to add signature lines for program directors to sign on separate sheets in an excel workbook. The problem I am having is this: if I add a signature line to any one sheet, the director's signature locks the whole document. I would like them to be able to sign one sheet for each month, so they are signed at the end of each month, but have multiple months and quarterly statements in the same document.

Any ideas on how to do this?

Thank you in advance!

[tdoen]

So it looks like this post has been viewed quite a bit, but no one has replied. I am guessing that means that what I'm asking can't be done. Any suggestions on a better way to do this? Maybe splitting the sheets into separate documents? I know how to do that. But if anyone has a suggestion for a quick and easy way to have people input and sign separate Excel sheets that are linked together (i.e., data from one is pulled to another), that would be really helpful. Thank you!

[dflak]

Just where are you putting the signature line? If it is in a fixed cell location in the document, then I don't know what the issue is. You can have a tab name / director name table and then populate the signature blocks on each page before printing. This could be done with a simple UDF that looks at the sheet name, finds the director's name in the table and plops it in.

[tdoen]

Hello Dflak, and thank you for the reply. I know how to enter a signature line, and there is one in a fixed cell on each sheet of the workbook. The problem is this- when the director electronically signs the January sheet, Excel makes that mean that the entire workbook is signed, not just the January sheet. So any changes made after the January sheet is signed (such as entering data in the February sheet) makes the January signature invalid. Thanks again!

[dflak]

It looks like you will have to split them out into individual files. Good luck.

[tdoen]

Agreed. I don't think that Excel allows me to do this. Many thanks for the replies.