Protect "signature" cell
Thanks Ron, this might work.
So, anyone can "fill out the form" and email it to the CFO.
He would "initial" (which anyone could do), but he approves the form.
Then the CFO has to remember to Save it into the "network" folder that is
secure, only a limited group can put it in the folder, but many can look at
it.
Is that correct?
It's not nearly as much fun as learning more excel, but sounds very
practical :-)
Thanks again.
"Ron Coderre" wrote:
Considering how easily Excel passwords can be broken, you might consider
something like this:
Create a network folder for approved files. Engage network security that
only allows approvers to write to that folder. That way, any file in that
folder had to be put there by an approver (or a network adminstrator, of
course).
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"DTTODGG" wrote:
Good morning, Excel gurus!
I have a spreadsheet where I have protected the workbook and worksheet
except for the input fields.
I have one cell that I would like to use as a "approved by" cell. I would
like all users to enter the data in the other "unprotected" cells. But this
one cell I would like password protect. Can I use a different password than
the worksheet pswd? If not, that's OK - just asking.
So, what I would like is when you tab to that cell, you get a password
prompt? Only the CFO (and me) will know the password - so when his initials
are in the box, we know he "approved" the file.
Bonus question, after he "initials" the cell, can I lock the entire sheet?
This is a cheap version of a "digital signature" :-)
Thanks a bunch!
|