Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Once data is entered into a cell I need it to be protected (automatically)
and not able to be changed or deleted. I am using this for a auditing receivables and once I see the receivable on the spreadsheet, I do not want anyone to be able to change or remove it. Need to also be able to add additional receivables to spreadheet. A formula that if a cell has data it becomes protected was my thought but ???. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect IF statement AND allow data entry | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |