Transition Navegation Key

C

cmart02

I am bringing this question forward because I am more intrigued now than
before and I do not want to lose it.

Does anyone know how to change the registry for the following (see messages
belows):

CONVERSATION STARTS HERE (Dave, if you read this thread, could you let me
know how to do it? Thanks, Rob)

This is a setting that's stored in the Windows registry.

Maybe that other person doesn't have write access to the registry. (So the
setting never gets really changed.)
 
C

cmart02

I managed to figure it out!!

Dave, thanks for the tip. I went to the Registry and found where the option
was! I played with it and got it eventually. Have suggested this to my friend
but still don't know what happened... I will post in case of goods news
(whether on the "Write Access" or not)

For those who do not know:

1) Start --> Run
2) Type: regedit
3) Hit "enter"

Expand as follows:

1) HKEY_CURRENT_USER
2) Software
3) Microsoft
4) Office (your version, mine is 10.0)
5) Excel
6) Options
7) Double-click on Option3 - REG_DWORD (right-hand side of box)

Change value from 3 to 40

I don't know if these values apply for all versions of Excel, though, but it
worked fine for me.
 
G

Gord Dibben

cmart02

Excel 2002 and 2003......

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Excel\Options

XX is your version of Excel...8,9,10,11

On the righthand pane you will see several Options keys

Options3 with Transition Navigation Keys checked in Excel will read (66)

Options3 with Transition Navigation Keys unchecked in Excel will read (64)

Modify that key.


Gord Dibben Excel MVP
 
G

Gord Dibben

Correction in-line

cmart02

Excel 2002 and 2003......

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Excel\Options

XX is your version of Excel...8,9,10,11

On the righthand pane you will see several Options keys

Options3 with Transition Navigation Keys checked in Excel will read
0x0000042(66)

Options3 with Transition Navigation Keys unchecked in Excel will read
0x000040(64)


Modify that key.


Gord Dibben Excel MVP
Click to expand...
 
D

Dave Peterson

First, if you're screwing with the registry, back it up first. (You don't want
an expensive door stop.)

In xl2002:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\10.0\Excel\Options

Option3
for me, it had a hex value of: 4082
with that transition setting checked.

it had a value of: 4080
with that setting unchecked.

I'd guess you should subtract 2 from what you see in that value.


ps.
4080 Hex = 16512 Dec
4082 Hex = 16514 Dec

===============

Personally, if I couldn't get our IT staff to help me solve the problem writing
to my registry, I'd have a workbook in my XLStart folder. This workbook's only
purpose would be to toggle that setting and close itself (to get out of the
way).

Option Explicit
Sub auto_open()
Application.TransitionNavigKeys = False
ThisWorkbook.Close savechanges:=False
End Sub

Each time excel opens, it would open this workbook. The workbook would do its
stuff and close.
 
D

Dave Peterson

Just to add.

You saw that your values for Option3 varied from both Gord's and mine.

Option3 holds more than this one setting. So you want to be a little careful!
 
Top