KC,

I also tried to use the list function paired with a validation. I created
the list off screen in a non-printing part of the sheet. I then targeted the
validation to each line of the list individually, unlocked the validated
cells and the list's cells, locked the worksheet and again excel stopped me.
This time it told me: You are attempting to move cells in a list. If I
focused on a cell in the list, no problem, except that the insertion wouldn't
add a row to the printable section of the sheet.

I know there must be a way to do this!
--
Riker1074


"KC Rippstein" wrote:

If you're using Excel 2003 or higher, Excel's "List" functionality (under the
Data menu) is great for inserting rows which retain the formulas and
formatting of the row directly above it without needing to copy & paste.

Just highlight your header row and data area and hit Ctrl+L to convert it to
an Excel List.

This function also converts the header row into an Auto Filter.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Riker1074" wrote:

Thanks Luke, but I didn't want to allow users to select locked cells.

Besides, the users of the file wouldn't know how to do what you suggested, I
really need a way to automate the process so it requires no action on the
part of the user. My target audience is office-illiterate
--
Riker1074


"Luke M" wrote:

When you go to insert, copy the row above where you want to insert, then
right click, paste special formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Riker1074" wrote:

I have a protected worksheet that allows any user to insert new rows. Each
row has 2 formulas and 2 validation managed cells. When a user inserts a
row, the validation is copied, but the formulae are not. How can the
formulae be fromated to fill on inserted rows.
--
Riker1074