Printable View
How can I detect a "leave cell event" in Excel? I have a small number of cells that can receive input data whereas the rest are protected. After the user has typed something in a cell and hits "enter" or "tab" I want the next cell of the set to receive focus and so on. Is that possible?
As part of your protection of the worksheet, only allow unlocked cells to be selected. Tht will force both Tab and Return to move to the next unlocked cell.
But how can I do that (what menu...)? Maybe it's an option in excel 2000, 2003... I'm currently testing the spreadsheet under Excel 97.Quote:
Originally Posted by DKenny
Oh my, I was right in supposing that, I just went to a computer with Excel 2003 and there is the nice little option...Quote:
Originally Posted by krtxmrtz