Cell positions after pressing Enter or Tab
Posted by HelpMe on September 05, 2001 5:21 AM
I've got a problem with Excel. I hope someone can help me? I want that after pressing Enter or Tab that the selected cell will change from the point where it's at at that time to a different one. For example when cell C5 is selected and after pressing Enter or Tab that cell C7 is selected and after pressing Enter or Tab after that one that cell D14 is selected. I hope someone is able to help me?
HelpMe
Posted by Jimmy on September 05, 2001 5:26 AM
You must select the cells that want to be able to tab to and then unlock them. Select the cell, right click, select format cells, then the protection tab. After you have each cell unlocked that you want then protect your sheet.
Posted by Dax on September 05, 2001 5:27 AM
One way you could do it is this.
Using your example, say you want to tab from cell C5 to C7 to D14 and then back to C5. If you highlight each of these cells in turn, click Format, Cells, protection tab and uncheck the Locked checkbox. Now protect the sheet. You'll find that if you press tab you'll move between those cells. However, this doesn't work for pressing Enter. For this I think you'd need to use some VBA code.
Regards,
Dax.
