Results 1 to 5 of 5

Move cursor to specific cell after Enter whether or not data's input, in protected sheet

Threaded View

kirkub Move cursor to specific cell... 04-06-2014, 05:12 AM
6StringJazzer Re: Move cursor to specific... 04-06-2014, 07:57 AM
kirkub Re: Move cursor to specific... 04-06-2014, 03:38 PM
6StringJazzer Re: Move cursor to specific... 04-06-2014, 04:15 PM
kirkub Re: Move cursor to specific... 04-06-2014, 04:44 PM
  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Move cursor to specific cell after Enter whether or not data's input, in protected sheet

    Hi all,

    I've looked all over this board and the web and can't find the answer to this exact problem.

    In a protected sheet, the unlocked cells are columns B through L. If the cursor is within columns E through L, after hitting Enter I need the cursor to move to cells in a particular column (to be exact: it needs to go one row down, column E).

    I've figured out that if I do this...:

    Option Explicit
     
    Private Sub Worksheet_Change(ByVal Target As Range)
         
        If Target.Cells.Count > 1 Then Exit Sub
         
        Select Case Target.Column
        Case 5
            Cells(Target.Row + 1, Target.Column).Select
        Case 6
            Cells(Target.Row + 1, Target.Column - 1).Select
        Case 7
            Cells(Target.Row + 1, Target.Column - 2).Select
        Case 8
            Cells(Target.Row + 1, Target.Column - 3).Select
        Case 9
            Cells(Target.Row + 1, Target.Column - 4).Select
        Case 10
            Cells(Target.Row + 1, Target.Column - 5).Select
        Case 11
            Cells(Target.Row + 1, Target.Column - 6).Select
        Case 12
            Cells(Target.Row + 1, Target.Column - 7).Select
        Case Else
            Exit Sub
            
        End Select
         
    End Sub
    ... I get half of the desired effect. Hitting Enter after inputting data in columns E through L takes me to the next row, column E.

    However, I also need to be able to jump to the same place if I click on a cell (or tab to it) without inputting data (it may already have data, or may be blank), and hit Enter. What do I need to add / change?

    The sheet's protected, some cells are locked and I can't use arrow keys or tab to get to the desired cell (the spreadsheet's been used for years, the users want "Enter", period). It has to be "hit Enter (with or without inputting data), go to row + 1, column E".

    Thank you for any suggestions!

    Kirk

    Edit: it needs to work in Excel 2007 up to 365.
    Last edited by kirkub; 04-06-2014 at 05:20 AM. Reason: Added version number

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-18-2013, 04:18 PM
  2. Move after Enter wont disable in protected sheet
    By rtullier in forum Excel General
    Replies: 2
    Last Post: 02-12-2013, 06:32 PM
  3. 'Move Selection after Enter' when sheet is Protected
    By kilgrow.jp33 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2011, 05:51 PM
  4. [SOLVED] Hitting Enter to Move Cursor to the Next Entry Cell
    By Cisnerax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2006, 07:10 AM
  5. [SOLVED] In a protected sheet how do I get the cursor to only move to unlo.
    By PapaBear in forum Excel General
    Replies: 2
    Last Post: 04-22-2005, 05:06 PM

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