I have a spreadsheet with certain cells containing formulas. I want to lock
those cells and have them skipped over by the user. There are other fields
where data MUST be entered. There is also a blank column where the user can
copy cells and do their own calculations. This entire column is unlocked.
However, as soon as I protection the sheet, stating that they cannot access
locked cells, but can select and format unlocked cells, AUTOSUM is shaded out
and does not work!. If I turn off the protection, it works again. HELP!