Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protect specific cell but allow edit on other cell | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions | |||
protect cell | Excel Worksheet Functions |