Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Partially protect a cell?
Is there a way that I can protect the formula in a cell, and its format, but
still allow a user to change the contents? It's for an expense report. The users need to enter their amounts, but the cells have formulas that need to be protected. Thank you! |
#2
|
|||
|
|||
You can unlock the cells that you want users to type in, then protect
the worksheet. To unprotect cells: Select the cells Choose FormatCells On the Protection tab, remove the check mark from Locked Click OK To protect the worksheet, choose ToolsProtectionProtect Worksheet. KathyHL wrote: Is there a way that I can protect the formula in a cell, and its format, but still allow a user to change the contents? It's for an expense report. The users need to enter their amounts, but the cells have formulas that need to be protected. Thank you! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Once the user input their amounts into the cell, the formula is gone. Input and formula need to be on different cell. KathyHL Wrote: Is there a way that I can protect the formula in a cell, and its format, but still allow a user to change the contents? It's for an expense report. The users need to enter their amounts, but the cells have formulas that need to be protected. Thank you! -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=390711 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions | |||
protect cell | Excel Worksheet Functions | |||
How do I protect one cell in a spreadsheet? | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |