View Single Post
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

TL,

You can hide all the columns past column N, and the tab will stop at column.
If youve been tabbing, from column A for example, and have arrived in column
N, the Enter key will return you to column A, one row down. Otherwise, you
can use the Home key to get back to column A, then the Enter key do go down
one row.

If that isn't good enough, you can set the scroll area to A:N. Then the tab
key will wrap back to column A. But you'll have to have a macro to set that
property again whenever the workbook is opened, as it isn't persistent. Put
this in module ThisWorkbook:

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A:N"
End Sub

You'll get the "This workbook contains macros" bit, unless you get a
certificate, set the security to high (Tools - Options - Security - Macro
security), and turn around three times.
--
Earl Kiosterud
www.smokeylake.com

"TL" wrote in message
...
I have an invoice created in excel that I would like to be able to tab over
no further than the end of the invoice(column N) and then return to column
A.
Howeer, the tab continues past the column and I don't know how to lock it.