Protecting your formulas in multiple worksheets [Solved/Closed]
Posts Monday November 2, 2015Registration date
December 4, 2015
Nov 9, 2015 at 01:53 PM - Latest reply: rizvisa14481
Posts Thursday January 28, 2010Registration dateContributorStatus
January 6, 2016
- Nov 9, 2015 at 04:32 PM
Hello everyone, thank you in advance for any help I receive with is question.
I have multiple worksheets in a workbook that have formulas in them but I have different people entering data into them. So what I need to know is there a way to allow anyone to input data but not rewrite over any formulas in that cell (by accident)?
I know you can protect the worksheet but they cannot input data without having the password and then they could"accidentally" erase the formulas (they are some pretty long nested IF statements, so anyone working in excel knows they do not want to keep rewriting them because of a user input error).