+ Reply to Thread
Results 1 to 2 of 2

Visual Basic for invoice to set up tabs

  1. #1
    kimberly.ingram
    Guest

    Visual Basic for invoice to set up tabs

    I am wanting to set up a spreadsheet that I can have the tabs direct straight
    to the areas that have to be filled in. That way it does not go to areas that
    dont need to be changed.
    IE. Tab from C2 to D5 to A25 ect

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Kimberly,

    Select the cell(s) you want to Tab to go to and do this...

    1) Press ALT + O
    2) Press E
    3) You should see the Format Cells dialog. Click the "Protection" tab
    4) Press ALT + L
    5) The "Locked" check box should be cleared. If not repeat step 4.
    6) Press "Enter" or click "OK"
    7) Repeat steps 1 - 6 until you are done


    Now you need to Protect the Worksheet for this to take effect...
    1) Press ALT + T
    2) Press P
    3) Press P
    4) Enter a Password if you want to, it's optional
    5) Press "Enter" or click "OK"

    You're done.

    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