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.

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.

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

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.

You can hide all those columns by:

Edit|Goto
type in o1:iv1
format|column|hide

Another option is to unlock the cells you want the user to be able to change
(format|cells|protection tab|uncheck lock).

Then protect the worksheet (tools|Protection|protect sheet)

Then tabbing will only go to those unlocked cells.

(But lots of features will be disabled in protected worksheets.)

TL wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

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.

--

Dave Peterson

Select columns O through IV and FormatCellsProtectionLocked.

Select Columns A through N and format as unlocked.

ToolsProtectionProtect Sheet.

The Tab key will move across to N then back to A one column down.

Alternative with no protection........

Starting in column A, use the Tab key until you want to leave N then hit ENTER
key to return to column A one row down.


Gord Dibben Excel MVP

On Mon, 8 Aug 2005 09:42:17 -0700, "TL" wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

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.

Thank you, this worked, now I have two options.

"Dave Peterson" wrote:

You can hide all those columns by:

Edit|Goto
type in o1:iv1
format|column|hide

Another option is to unlock the cells you want the user to be able to change
(format|cells|protection tab|uncheck lock).

Then protect the worksheet (tools|Protection|protect sheet)

Then tabbing will only go to those unlocked cells.

(But lots of features will be disabled in protected worksheets.)

TL wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

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.

--

Dave Peterson

Thank you, this also worked.

"Gord Dibben" wrote:

Select columns O through IV and FormatCellsProtectionLocked.

Select Columns A through N and format as unlocked.

ToolsProtectionProtect Sheet.

The Tab key will move across to N then back to A one column down.

Alternative with no protection........

Starting in column A, use the Tab key until you want to leave N then hit ENTER
key to return to column A one row down.


Gord Dibben Excel MVP

On Mon, 8 Aug 2005 09:42:17 -0700, "TL" wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

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.