Locked / unlocked sheet and cells

[Michael M]

Hi All
This one is doing my head in !!
I have a workbook with the top half of the sheet locked, to do calculations.
The rest of the sheet is unlocked for a work area.
Everything works fine, except ......
If the user inserts a new line in the work area, or they hit the save button,which they should be able to do, they then lose control of the down arrow.
So a row is added say Row 25, they do a bit of work in say Row 21 and want to move the row 22 by using the down arrow and when they press the down arrow it usually moves acouple of rows and then jumps back up to the start of the work area again....in any column.

I've checked for incorrect locked cells, Page setups, Print areas, scroll area, VBa properties for each sheet. I've even written code for Auto Open, so that ALL cells below a certain row are unlocked...but the minute they either Save or Insert a Row, back to insanity again !!!
Any clues

 

[diddi]

i had the same thing and never resolved it. a couple of things to check: have you got any rows where rowheight=0. i found it tended to happen more in filtered sheets.

cold today. no golf for u

 

[Michael M]

Hi P
Nope, checked that as well. Also created a new workbook and dragged the sheets across, still no luck !!




Played yesterday, 13 deg....tomorrow will be better.