btw-- no passwords, the lock function error happens if you go home (ctl+home) and end up at A1

Is it possible to use dynamic named ranges...(ie..Range = Totals (I22:M24,-K23) where the rows change as the macro adds rows above)?

If so, naming ranges of cells; DataEntry, SubTotals, Totals, TitleHeaders & DeadZone
then, using named ranges to control protection for each range independently.

can the deadzone (area outside of the worksheet) be named so you can add code to lock it down.


</IMG>