I've created a spreadsheet for tracking my weekly time at work, it has serveral worksheets for summaries and totals, etc. there are about 6 worksheets total out of the 6 there are only 2 that a user should manually manipulate, all others are altered based on the info entered on the those two. I have to roll this out to my team, and want to know if there is a way I can lock the 4 worksheets that do not need manual intervention but will still function as needed (updating when the 2 worksheets are changed).
Note: Might be good to also know if I can lock portions of the editable worksheets as well, things like headers/Titles, etc. ?
Thanks in advance for any help