Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?

if you are talking about the tab that usually says "sheet1", "sheet 2", etc.
then yes you can i fyou have excel 2003, simply by right clicking the tab and
going to tab color

--
--Chip Smith--



"Kycajun" wrote:

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?

You cannot change the Tab order of unlocked cells in a sheet.

Left to right and top to bottom is the order.

You can use other methods to give a Tab order of your choosing.

See Bob Phillips' site for help on the "named range" method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can also use VBA event code to set an order.

Post back if you want an example of that.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 08:29:50 -0700, Kycajun
wrote:

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?

I am actually reading up on Macros (VBA) right now. I have never ventured
that far into Excel, so this is brand new territory for me. I read a couple
of other posts that say you can set up a macro to run your preferred tab
order. If you have any help or if you think your example may help me get
started, I would love the help. If not, wish me luck ~ I think I have a lot
of reading to do! Thanks to all for the replies.

"Gord Dibben" wrote:

You cannot change the Tab order of unlocked cells in a sheet.

Left to right and top to bottom is the order.

You can use other methods to give a Tab order of your choosing.

See Bob Phillips' site for help on the "named range" method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can also use VBA event code to set an order.

Post back if you want an example of that.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 08:29:50 -0700, Kycajun
wrote:

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?

Here is the example.

''moves from C2 through E5 at entry of data
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

This worksheet event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module..

Adjust the cell refs and add more Cases as you need.

NOTE: the ENTER key can be used as well as the Tab key.


Gord

On Wed, 21 Jun 2006 10:39:01 -0700, Kycajun
wrote:

I am actually reading up on Macros (VBA) right now. I have never ventured
that far into Excel, so this is brand new territory for me. I read a couple
of other posts that say you can set up a macro to run your preferred tab
order. If you have any help or if you think your example may help me get
started, I would love the help. If not, wish me luck ~ I think I have a lot
of reading to do! Thanks to all for the replies.

"Gord Dibben" wrote:

You cannot change the Tab order of unlocked cells in a sheet.

Left to right and top to bottom is the order.

You can use other methods to give a Tab order of your choosing.

See Bob Phillips' site for help on the "named range" method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can also use VBA event code to set an order.

Post back if you want an example of that.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 08:29:50 -0700, Kycajun
wrote:

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?



Gord Dibben MS Excel MVP

Thanks a bunch. I will get started on it here shortly. I appreciate the
help.

"Gord Dibben" wrote:

Here is the example.

''moves from C2 through E5 at entry of data
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub

This worksheet event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module..

Adjust the cell refs and add more Cases as you need.

NOTE: the ENTER key can be used as well as the Tab key.


Gord

On Wed, 21 Jun 2006 10:39:01 -0700, Kycajun
wrote:

I am actually reading up on Macros (VBA) right now. I have never ventured
that far into Excel, so this is brand new territory for me. I read a couple
of other posts that say you can set up a macro to run your preferred tab
order. If you have any help or if you think your example may help me get
started, I would love the help. If not, wish me luck ~ I think I have a lot
of reading to do! Thanks to all for the replies.

"Gord Dibben" wrote:

You cannot change the Tab order of unlocked cells in a sheet.

Left to right and top to bottom is the order.

You can use other methods to give a Tab order of your choosing.

See Bob Phillips' site for help on the "named range" method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can also use VBA event code to set an order.

Post back if you want an example of that.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 08:29:50 -0700, Kycajun
wrote:

Can you change the tab order in a worksheet? I have a checklist I have
compiled in a worksheet and with most cells locked, but have unlocked all
cells which need input. The tab order is of course left to right, is there
any way to customize this (much like you can in Access)?



Gord Dibben MS Excel MVP