M
Michael Weinhardt - MSFT
Hi,
[for Excel 2007]
I have a worksheet with one data table. The cells in the data row that have
formulas are locked - to avoid changing the formula and to remove them from
the tab order. All other cells in the worksheet are unlocked.
When I protect the worksheet, and make sure to check the options that allow
me to insert rows, I am still not allowed to insert new data table rows. For
example, pressing TAB at the end of one data row will not automatically
create a new row and shift the focus to the first cell in the new row.
Unprotecting the worksheet gives me the desired row insertion but without the
cell protection.
How can I configure the data table to lock certain cells in each data row
*and* retain the automatic row insertion I've come to know and love?
Oh, and is this possible *without* code?
Thanks!
Michael
[for Excel 2007]
I have a worksheet with one data table. The cells in the data row that have
formulas are locked - to avoid changing the formula and to remove them from
the tab order. All other cells in the worksheet are unlocked.
When I protect the worksheet, and make sure to check the options that allow
me to insert rows, I am still not allowed to insert new data table rows. For
example, pressing TAB at the end of one data row will not automatically
create a new row and shift the focus to the first cell in the new row.
Unprotecting the worksheet gives me the desired row insertion but without the
cell protection.
How can I configure the data table to lock certain cells in each data row
*and* retain the automatic row insertion I've come to know and love?
Oh, and is this possible *without* code?
Thanks!
Michael