Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |