View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_135_] Leith Ross[_135_] is offline
external usenet poster
 
Posts: 1
Default 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