Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic for invoice to set up tabs
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 -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=479875 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual Basic and SP2 | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
creating a VERY BASIC invoice system | Excel Discussion (Misc queries) |