Is there any way for code to recognize where a selection change originates and dictate what happens in different cases? For example, in the code below, I have the active cell move to the right in all cases (to protect certain cells from cell entry). But now when I use my arrows to navigate to the left on the worksheet, it won't work because the code automatically shifts it back to the right. Is there a way to specify that if it comes from the left or from a mouse click, it moves right, but if it comes from the right it moves to the left? (This way it'll still protect the cell from entry, but it makes navigating easier). And same for up and down? So then it will basically act as if the cells are protected in the worksheet, you'll be able to navigate right over them. I wasn't sure if there's an argument to allow the code to recognize in which direction the activecell is moving, and dictate where it should move based on that. Thanks!
Bookmarks