Change Focus on Cell Select

[thesonofdarwin]

I'm attempting to change the focus when you select a cell. This is what I have thus far, but it is not working. Any suggestions?

Please Login or Register  to view this content.

[StevenM]

Instead of:

Please Login or Register  to view this content.

How about:

Please Login or Register  to view this content.

[davesexcel]

Hi,

Please explain what is supposed to be happening.

[thesonofdarwin]

Thanks, StevenM, but that did not work.

Dave, I want the focus to switch from cell Template!C18 to Ranges!C2 when you click on Template!C18.

[davesexcel]

This should do it then

Please Login or Register  to view this content.

Place this in the "Template" worksheet module.

[StevenM]

Copy and place in worksheet module "Template":

Please Login or Register  to view this content.

[thesonofdarwin]

Neither of those work either. Is there something I need to enable to make this happen? My security is set to allow Macros and I've not had problems previously getting code to work.

[davesexcel]

The worksheet spelling has to be exact, and you need to place the code in the worksheet module.
Right click on the "Template" sheet tab and select view code, paste the code there.

[thesonofdarwin]

http://imgur.com/c5Hl8

Posted the cell/worksheet names directly from Excel. Image of where I'm placing this code.

[StevenM]

That looks correct. I'm at a loss here, the code worked for me.

[thesonofdarwin]

As am I because I just tested it on a black workbook and it worked fine...

There's a formula in the target cell but I wouldn't think that'd be an issue.

[davesexcel]

Your picture does not show the code I gave you.

[thesonofdarwin]

No it shows Stevens. The image is merely to show where I'm placing the codes you are suggesting.

I've tested both of your codes in a fresh workbook and they both work, which tells me the problem is not with the code but with the workbook.

Attached is the workbook if you would like to take a look.

[davesexcel]

Nowhere did you mention that the target cell was a merged cell!!!

Please Login or Register  to view this content.

It is not good practice to use merged cells.

[thesonofdarwin]

Ugh, sorry for the headache! I know using merged cells is not ideal, but the format and required information on each page is set in stone for now. I have to work within those requirements.

Thanks for the assistance, guys.