Can't insert row in data table in protected worksheet

  • Thread starter Michael Weinhardt - MSFT
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top