| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I change the tab order in a protected worksheet?
I would like to be able to change the tab order when entering data in a
protected worksheet. The default is to tab across the page and then to the next row. There are some instances where I need to go down and then across. |
|
#2
|
|||
|
|||
|
Check out Bob Phillips' site for methods.
http://www.xldynamic.com/source/xld.xlFAQ0008.html Note: there is another method using event code in a worksheet module. Post back if you want to consider that. Gord Dibben Excel MVP On Tue, 17 May 2005 10:15:28 -0700, "sciservice" wrote: I would like to be able to change the tab order when entering data in a protected worksheet. The default is to tab across the page and then to the next row. There are some instances where I need to go down and then across. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| On a excel protected worksheet, how do I change the tab order? | Excel Worksheet Functions | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
| How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
| change font when sheet is protected | Excel Discussion (Misc queries) | |||
Linear Mode
