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!

Why not just lock the cell?



"Jeremy" wrote:

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!

.

I have locked the cells I want to skip over. However that has no effect
unless one protects the sheet. If you protect the sheet you can't add more
records to the List (or Table as it's called in Excel 2007).
Jeremy

"Leung" wrote in message
...
Why not just lock the cell?



"Jeremy" wrote:

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!

.

When you apply the protection to the sheet, use the UserInterFaceOnly
argument.

See http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm.

Alan