ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controlling Tab order (https://www.excelbanter.com/excel-programming/310633-controlling-tab-order.html)

jpendegraft[_23_]

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


Frank Kabel

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?




All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com