The minute I use this macro (which I made myself, I might add!), it brings up the dialog, and I put a name in and say OK...
Then, my arrow keys don't work no more!!Sub MakeName() Application.Dialogs(xlDialogDefineName).Show End Sub
What's up with that?
Anybody else?
~Anne Troy
What macro?
What? You can't see the macro I put up there? (hee hee, sorry!!)
~Anne Troy
I tried running the macro from a button and Tools | Macro | Macros... and added a name and pressed Ok. After that my arrow keys still work fine and I can move around to different cells.
Excel 2003.
MAYBE it's cause I have assigned it to a textbox from the drawing toolbar? Mind testing? Hmm...I'll test in 2003 while I'm at it.
Doh! I am in 2003
~Anne Troy
Nope, worx fine on mine (2000)...Originally Posted by Dreamboat
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Wow, that is a very strange error. After running the macro from a Drawing Toolbar Text Box the arrow keys break.
Maybe the Text Box keeps the focus even though I can select another cell with the mouse and still cannot use the arrow keys.
Why can't you just use the keyboard shortcut: Ctrl + F3 ?? (That's what I use.)
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
That's two buttons. She wants to be more efficient and reduce that to one click.
I think this one goes into the Excel Twilight Zone file, however I found a solution!
Sub MakeName() Application.Dialogs(xlDialogDefineName).Show Application.TransitionNavigKeys = Not Application.TransitionNavigKeys Application.TransitionNavigKeys = Not Application.TransitionNavigKeys End Sub
This sets the Transition Navigation Keys option (Tools, Options, Transition) to the opposite of its current setting, then back again. No idea why it should work but it does
I think this one goes into the Excel Twilight Zone file, however I found a solution!
Sub MakeName() Application.Dialogs(xlDialogDefineName).Show Application.TransitionNavigKeys = Not Application.TransitionNavigKeys Application.TransitionNavigKeys = Not Application.TransitionNavigKeys End Sub
This sets the Transition Navigation Keys option (Tools, Options, Transition) to the opposite of its current setting, then back again. No idea why it should work but it does
Hi geekgirl,
Good one!But I found the second iteration not necessary (2000)... Let's see if it's the same for the others...
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
VERY interesting!!
I'm working on a project where I may be inserting bunches of named ranges, so I just GOTTA have the button...
~Anne Troy
Hi John,
The purpose of the second iteration is to reset back to the original transition keys setting.
Posting Permissions
Reply With Quote
