Skip over a (calculated) cell in a Table
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! |
Skip over a (calculated) cell in a Table
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! . |
Skip over a (calculated) cell in a Table
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! . |
Skip over a (calculated) cell in a Table
When you apply the protection to the sheet, use the UserInterFaceOnly
argument. See http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm. Alan |
All times are GMT +1. The time now is 01:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com