Tab Order

[Pesky_Weasel]

Dear All,

Can Tab Order be set for a number of cells in worksheet?

Regards
Weasel

 

[Andrew Poulsom]

You could use the OnKey method in VBA to trap the TAB key and have Excel act in the way you want.

Post a sample of your data, specifying the action to be taken when TAB is pressed.

 

[stevebausch]

Don't forget about the "Move selection after Enter" option in Tools-Settings.

There are also .EnableSelection and .ScrollArea properties for each worksheet.

These can also be used to modify the behavior of Enter and Tab keys.

 

[Pesky_Weasel]

Thanx Guys,

I will investigate both, but for its late and Im drunk, so off to bed.

The Weasel

 

[pmdown]

If You'l be sober, and have Excel XP, may try This:

Select and mark some cells als unlocked.
Lock the sheet, but allow select only unlocked cells.

It's help ?

Baboon and Weasel.