G
Guest
I have a workbook that has 7 worksheets. The worksheets are filled with lots
of formulas. I want to be able to stop anyone from changing or altering the
formula, on purpose or by mistake. Is there away to do this and still allow
for data entry? Or do I need to lock the columns with formulas and then
leave the columns for data entry unlocked? I've played around with the
protection tab and it seems to lock the whole worksheet and not allow data
entry. I'm at a loss and would love any suggestions. Thanks!
of formulas. I want to be able to stop anyone from changing or altering the
formula, on purpose or by mistake. Is there away to do this and still allow
for data entry? Or do I need to lock the columns with formulas and then
leave the columns for data entry unlocked? I've played around with the
protection tab and it seems to lock the whole worksheet and not allow data
entry. I'm at a loss and would love any suggestions. Thanks!