Transition Navigation Keys

[drdcarlos]

Hi, I'm having problems with my TAB Key. I go to Tools-> Options ->
Transition Navigation Keys and uncheck it.

However, everytime that I open Excel it is checked again. How can I
change that once for all?

tks

 

[Guest]

check out "customize how Excel Opens" in the help section

 

[Dave Peterson]

I think that this is one of those settings that's stored in the windows
registry. If your changes aren't being saved, it may be worthwhile to talk to
your IT folks to find out why you can't save to the registry.

Maybe you're not an administrator for your pc (or you're logged on as a user who
doesn't have those rights).

But until you get it fixed, you could put a workbook in your XLStart folder.
That means the workbook will open each time you start excel.

The code could turn the setting off and close the workbook.

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm