+ Reply to Thread
Results 1 to 1 of 1

Code to recognize where selection change active cell originates

  1. #1
    Forum Contributor
    Join Date
    09-30-2008
    Location
    Eau Claire, WI
    Posts
    184

    Code to recognize where selection change active cell originates

    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!

    Please Login or Register  to view this content.
    Last edited by jman0707; 11-15-2008 at 01:55 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1