+ Reply to Thread
Results 1 to 3 of 3

change the tab movement

  1. #1
    Forum Contributor
    Join Date
    08-20-2005
    Posts
    173

    change the tab movement

    I have a protected worksheet which by default is tabbing across, I
    need this to tap down and have inserted the code below within the worksheet
    to change the tab movement. This however has not worked. Regards


    Please Login or Register  to view this content.
    Last edited by T De Villiers; 04-04-2008 at 10:56 AM.

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    What exactly do you mean by it doesn't work? I inserted the procedure into a new workbook, and it appeared to work fine for me. Did you insert this into the Worksheet code module? (Not ThisWorkbook or a general code modue?)

    Of course, the above code will work only when the referenced cells change or are edited. Do you simply want to be able to tab to the various cells even if the cells do not change?

    Jason
    Last edited by jasoncw; 04-04-2008 at 01:25 PM.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello T De Villiers,

    Here is another macro to control the tabbing in the order want.

    User Controlled Tabbing Macro
    Please Login or Register  to view this content.
    How to Save a Worksheet Event Macro
    1. Copy the macro using CTRL+C keys.
    2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
    3. Left Click on View Code in the pop up menu.
    4. Paste the macro code using CTRL+V
    5. Save the macro in your Workbook using CTRL+S

    Sincerely,
    Leith Ross

+ 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