Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Tab order
I am working with a spreadsheet that contains merged and protecte cells. This has caused the normal "top to botom" tabbing to skip row that contain a protected cell. Imagine Row 2 Cells C, D and E are merged. Row 3 Cell E (E3) i protected. I would like the user to tab from Cell C2:E2 (remember i is merged) to C3..instead it skips to Row 4. How can I "correct" this -- jpendegraf ----------------------------------------------------------------------- jpendegraft's Profile: http://www.excelforum.com/member.php...nfo&userid=570 View this thread: http://www.excelforum.com/showthread.php?threadid=26179 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Tab order
Hi
maybe the following helps you: http://www.xldynamic.com/source/xld.xlFAQ0008.html -- Regards Frank Kabel Frankfurt, Germany jpendegraft wrote: I am working with a spreadsheet that contains merged and protected cells. This has caused the normal "top to botom" tabbing to skip rows that contain a protected cell. Imagine Row 2 Cells C, D and E are merged. Row 3 Cell E (E3) is protected. I would like the user to tab from Cell C2:E2 (remember it is merged) to C3..instead it skips to Row 4. How can I "correct" this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Controlling VBA | Excel Programming |