G
Guest
How can I determine the taborder in an excel sheet ? It needs to go from
a3 to b3 tot a4 to b4 to a5 to b5 etc.
a3 to b3 tot a4 to b4 to a5 to b5 etc.
G
Guest
Do determine what it currently is
Dim sh as Object
for each sh in Activeworkbook.Sheets
msgbox sh.name & " index: " & sh.Index
Next
Dim sh as Object
for each sh in Activeworkbook.Sheets
msgbox sh.name & " index: " & sh.Index
Next
I
Ian
With the order you specified, it's quite easy.
Select the cells you want to tab between (eg A3:B5), then go to
Format>Cells>Protection, deselect the Locked checkbox then click OK.
Go to Tools>Protection>Protect Sheet. In the dialog box you will be offered
the option to set a password. This is optional. Depending on the version of
Excel there may also be the option to specify what operations users can
carry out. For the purposes of this exercise, the defaults will do. Click
OK.
Tab will now move to the next available unlocked cell working along the row
before moving onto the next row.
The cells do not have to be in one group, but will always check an entire
row before going onto the next row.
Select the cells you want to tab between (eg A3:B5), then go to
Format>Cells>Protection, deselect the Locked checkbox then click OK.
Go to Tools>Protection>Protect Sheet. In the dialog box you will be offered
the option to set a password. This is optional. Depending on the version of
Excel there may also be the option to specify what operations users can
carry out. For the purposes of this exercise, the defaults will do. Click
OK.
Tab will now move to the next available unlocked cell working along the row
before moving onto the next row.
The cells do not have to be in one group, but will always check an entire
row before going onto the next row.
S
Susan
i don't believe the OP means "determine" as in find out what order the
sheets are currently in.
i believe he means to SORT them in the order he wants them.
(if i'm wrong, frans, then ignore me.
)
Sorting Worksheets Numerically
http://groups.google.com/group/micr...sort+worksheets&rnum=1&hl=en#56b601227e174f89
this thread discusses a lot of different options regarding sorting
worksheets.
hth
susan
sheets are currently in.
i believe he means to SORT them in the order he wants them.
(if i'm wrong, frans, then ignore me.
)Sorting Worksheets Numerically
http://groups.google.com/group/micr...sort+worksheets&rnum=1&hl=en#56b601227e174f89
this thread discusses a lot of different options regarding sorting
worksheets.
hth
susan
G
Guest
Misunderstood
to tab within the sheet. Select A3:B5 and move within the selection using
the Tab key. You can use the enter key as well if it is set to move right
after enter.
to tab within the sheet. Select A3:B5 and move within the selection using
the Tab key. You can use the enter key as well if it is set to move right
after enter.
G
Guest
You are right Susan. I am not english so sorry if I used the wrong words. I
want to be able to controle the tabbing order within a worksheet. Alle fill
in fields are filled in with a handscanner and thus the movement within the
sheet should go automatically. I hope I'm clear now.
want to be able to controle the tabbing order within a worksheet. Alle fill
in fields are filled in with a handscanner and thus the movement within the
sheet should go automatically. I hope I'm clear now.
G
Guest
Susan gave you a link for code to sort the sheet names (tabs) at the bottom
of the Excel windows. Based on your response, that is not related to what
you want. I previously posted this as my second attempt - since it should
have been visible when you posted, I will post it again here:
to tab within the sheet. Select A3:B5 and move within the selection using
the Tab key. You can use the enter key as well if it is set to move right
after enter.
of the Excel windows. Based on your response, that is not related to what
you want. I previously posted this as my second attempt - since it should
have been visible when you posted, I will post it again here:
to tab within the sheet. Select A3:B5 and move within the selection using
the Tab key. You can use the enter key as well if it is set to move right
after enter.
I
Ian
Tom's suggestion relies on the user selecting the area to restrict the
tabbing to. If you want to restrict entries ONLY to these 2 columns and
certain rows, then my suggestion of unlocking the cells and then protecting
the worksheet is more foolproof. Copied below:
Select the cells you want to tab between (eg A3:B5), then go to
Format>Cells>Protection, deselect the Locked checkbox then click OK.
Go to Tools>Protection>Protect Sheet. In the dialog box you will be offered
the option to set a password. This is optional. Depending on the version of
Excel there may also be the option to specify what operations users can
carry out. For the purposes of this exercise, the defaults will do. Click
OK.
Tab will now move to the next available unlocked cell working along the row
before moving onto the next row.
tabbing to. If you want to restrict entries ONLY to these 2 columns and
certain rows, then my suggestion of unlocking the cells and then protecting
the worksheet is more foolproof. Copied below:
Select the cells you want to tab between (eg A3:B5), then go to
Format>Cells>Protection, deselect the Locked checkbox then click OK.
Go to Tools>Protection>Protect Sheet. In the dialog box you will be offered
the option to set a password. This is optional. Depending on the version of
Excel there may also be the option to specify what operations users can
carry out. For the purposes of this exercise, the defaults will do. Click
OK.
Tab will now move to the next available unlocked cell working along the row
before moving onto the next row.