I have an (Excel 2003) list with some calculated columns in it. Users add
data to the botttom of the table as usual. When user tabs right from a cell
in which she has entered data, I'd like the cursor to skip over any
calculated columns, so that the user doesn't corrupt the formulas.
However, if I protect the sheet appropriately, users can't add new records
to the bottom of the list.
Is there a way to skip the calculated cells in an Excel 2003 list? I don't
want to have to create a data entry form.
Thanks!