In a locked spreadsheet, I want the user to be able to tab from one cell to another in an order that I set, not just to the next unlocked cell from left to right.
This will allow you to tab from all the cells in section A of the spreadsheet and then tab between all of the cells in section B and so on. At the moment, when you enter a value in the first cell of section A and then press tab, you move across into section B and so on.
Is it possible to have the tab key move the curser to each required cell in section A until its completed, then move to section B, section C etc
Thanks
This will allow you to tab from all the cells in section A of the spreadsheet and then tab between all of the cells in section B and so on. At the moment, when you enter a value in the first cell of section A and then press tab, you move across into section B and so on.
Is it possible to have the tab key move the curser to each required cell in section A until its completed, then move to section B, section C etc
Thanks