DH Templates

Microsoft Excel - Tabbing through fields no longer works.?

I created a Microsoft Excel Template that I use for invoicing. I used to be able to tab from field to field (unlocked cell to unlocked cell). I recently edited the template and made some minor changes. Now when I load the template I can only tab across one row, and I must click into the next row to move there. When I get to the end of the row it used to automatically drop to the next row and continue thru the document. It no longer does this. Also I have noticed I am unable to use the arrow keys to move up or down a row. Can someone help me fix this problem? Thats how it is supposed to work Clinky, but for some reason it isn't working like that.

Public Comments

1. It seems like you have changed a little bit more than you thought. One way to be able to make the cursor move down is to select an area, which will change to a light blue background, if you type data in and press enter, the cursor will move to right, until at the end of the line, then it will move down one column, and move back to first row.
2. When template is locked to a row instead of the pre-defined area when sheet is protected, one of the possible reason is a particular attribute of that particular sheet had been change. 1. Alt+F11 to open vba editor, on the left side, project window(if no, ctrl+r), click to highlight sheet1(invoice) 2. you should also have properties window, if not press F4, look for a line "EnableSelection", on its right, change from 1-xlUnlockedCells to 0-xlNoRestrictions, save the file while in vba editor. OR 2nd solution 1. remove protection of all type on all sheets, go to menu edit, move or copy sheet, copy sheet 1 by 1 to a new book, 2. protect the sheets again in new book, and then save it as template again. Hope this helps.