I need to select a range on a cell click

Hi. Someone I work for created a protected form and wanted the cells to be filled in in a specific order. I did this by creating a named range that is automatically highlighted when the workbook is opened. It works fine as long as the user just types in data and clicks tab or enter, but if the user clicks a cell, the range is no longer highlighted and the tab order goes back to default. I need some code that will select the range again if the user clicks any of the cells. The code I've used so far is below. I'm using Excel 2010 with the 64 bit version of Office. Thanks for any help you can give.

Option Explicit

Private Sub Workbook_Open()
Range("Fill_Order_2").Select
End Sub

It is the unlocked cells that he wants the user to fill in, chosen in the order he wants them filled in. The default order would be from top left to right to bottom left to right (a1, b1, c1, a2, b2, c2, etc.), but he wants the top part first, then the left side of the sheet, then the right side. I attached the file to the original post if anyone needed to see it to figure it out. Thanks.

The order is what is important, so Leith's answer won't work. Even when it is locked so other cells can't be selected, but selecting any cell makes the order go back to default instead of what I chose in my named range. As long as the range stays selected, the entries go in the order I want.

I tried the code and it turns off the range going from cell to cell and makes it go in an odd order different from the order of the code or how I set up my range.

Do you know if there is a code to initiate an event on a click? If so, I could use that like I use the code to select the range on open.

Thanks to both of you for trying.

Yeah I know...I checked the order. Instead of doing what it should, it basically just goes straight down the first column and then goes to the second. I'm looking around still for something that will select the range if a cell is clicked unless I can get your way to work somehow.

That would be true, but it would still preserve the order, and that is what the guy is going for. Going to the first empty cell would be fine with me, but before I can do that I have to get the range re-selected if they click instead of using tab or enter.

wow...that isn't working either and I was sure it would. I've tried some variations like using the range name and using Application.Goto with it and it still won't re-select the range. It acts like nothing is happening at all and even with protection on after I click in a cell it is letting me click in locked cells. I think I'm about to give up on it for a while and see if something comes to me while I'm not thinking about it. Thanks for trying to help.

no I'm not. I've tried using a new module and also putting it under my code for opening with the range selected. Where should I put it?

ok...i used the <> code you suggested earlier directly in the sheet1 code. It keeps the order, but obviously doesn't allow blank cells, and it skips over the cells that have 0 in them by default because they <> "". If you have any thoughts on fixing that, please let me know. thanks again. have a great weekend!

Now I'm using this:

Please Login or Register  to view this content.

At first it worked, but then I unprotected the sheet to correct a spelling error and when I protected the sheet again, it started going in the wrong order like the first one on Friday did where it went down the first part of the first column, then instead of going to the right part on the top, it went to the right part on the bottom and then just kind of randomly afterwards. It doesn't make sense because the order is listed and hasn't changed.