+ Reply to Thread
Results 1 to 6 of 6

Entry tabs

  1. #1
    Forum Contributor
    Join Date
    03-09-2007
    Location
    Australia
    MS-Off Ver
    Office 10
    Posts
    371

    Entry tabs

    I know how to do this in access but I cannot figure out how to do it in excel
    I want to have the cursor start on 1 [c5] and after enter move to 2 [c7] and so on
    Help appreciated as always
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Entry tabs

    The only way I know is to:
    1)right click the cells you want user to be able to change, choose format cells/protection remove tick from "locked". (I'm not using English Excel, so not sure all items are correctly translated).
    2)Protect the sheet (file/protect workbook/protect sheet) and uncheck "select protected cells"

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Entry tabs

    see the attached file
    Select all the Cells between which you want to move the courser.
    press Ctrl + ! (1) tab, select protection button then deselect the Locked Selection Button
    Select Protect Sheet under Review on Toolbar
    Under Protect Sheet deselect the select locked cells selection button
    then click OK button
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Contributor
    Join Date
    03-09-2007
    Location
    Australia
    MS-Off Ver
    Office 10
    Posts
    371

    Re: Entry tabs

    I have tried that but it does not work with Office 10
    Does not allow Macros to run
    But thanks for the suggestion

  5. #5
    Forum Contributor
    Join Date
    03-09-2007
    Location
    Australia
    MS-Off Ver
    Office 10
    Posts
    371

    Re: Entry tabs

    Thanks nflsales
    I will give that a Go
    Many Thanks

  6. #6
    Forum Contributor
    Join Date
    03-09-2007
    Location
    Australia
    MS-Off Ver
    Office 10
    Posts
    371

    Re: Entry tabs

    Cannot seem to replicate what you have in the example
    But thanks for the assistance

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto name tabs based on field entry / macro?
    By teenyjem in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2013, 11:20 AM
  2. Replies: 6
    Last Post: 09-18-2012, 05:04 PM
  3. Replies: 0
    Last Post: 07-25-2012, 05:40 PM
  4. Select Tabs based on cell entry
    By Sharp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2008, 07:43 AM
  5. [SOLVED] Can I protect all excel tabs in a file with one password entry?
    By Indiana born in forum Excel General
    Replies: 3
    Last Post: 12-20-2005, 12:50 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