moving thru locked

[iamtheeggman]

I have a protected sheet which the user inputs info in cells in columns B, D and F. In row 56 is a merged cell across A thru G. Using enter to move from cell to cell I am only able to move thru the unlocked cells in column B and into the merged cell and back to the first unlocked cell in B again. It should move thru the cells in B first then D then F. I guess the merged cell is causing the problem but is there a way to go thru the cells in B then the cells in D then the cells in F and finish in the merged cell at the end. The user puts daily sales numbers in the cells and uses the big merged cell to record notes about anything which may have happened during the day. ANY THOUGHTS??

 

[erik.van.geit]

hello,
why not reply in the original thread ?
http://www.mrexcel.com/board2/viewtopic.php?p=869610&highlight=#869610