Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change series plotting order without changing legend order? PatrickM Charts and Charting in Excel 6 December 2nd 09 07:43 PM
For chart syles, why doesn't color order match series order? AMiller Charts and Charting in Excel 1 October 29th 09 12:02 AM
How stop Excel file UK date order changing to US order in m.merge Roger Aldridge Excel Discussion (Misc queries) 1 October 9th 07 11:52 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Worksheet Functions 1 November 17th 04 01:59 PM
Controlling VBA MWE[_3_] Excel Programming 2 January 13th 04 07:23 PM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"