Alt-F11 to open VBE has stopped working!

[Jolly Green Giant]

Hi everyone.

I'm a newly registered member. Hope someone 'out there' can help me with this oddball problem....

I've been using VBE to build on recorded macros for many a year now. All self taught, learning more all the time. I'm a bit of a keyboard freak (ie keep my hands off the mouse as much as poss, for speed) and 'suddenly' my Alt-F11 keyboard shortcut, to open up the VBE, has stopped working!

I can't correlate this with any particular event (loading new software, installing add-in, customising toolbars, applying shortcut keys to macros, or anything else that I might suspect was a cause...).

Alt-key still works fine on its own, eg to access menus. F11-key still works fine on its own (creates chart). Other Alt-Function Key combinations still work (eg Alt-F8 to show Macro dialog box).

I can't find anyplace where a user can switch shortcut keys on or off or customise them.

I'm stumped!! Just hope someone out there can help as this is a big annoyance for me (considering it's such a small, incidental problem.)

 

[Richie(UK)]

Hi JGG,

Welcome to the forum

Keystrokes can be 'interfered with' via VBA using the OnKey method. It may be that a workbook / add-in disabled access in this way and didn't restore it on closing (possibly trying to prevent you looking at the code).

Can you still access the VBE via the Tools menu?

 

[Jolly Green Giant]

Thanks for the ideas, Richie.

Any clue on how I'd go about tracking such a culprit down?

I've tried unchecking the an Add-In or two from the Add-Ins dialog box (I seem to remember loading the Analysis Tools VBA recently for some reason) but I'm not sure if just closing and restarting Excel will register that change.

Also, I've used the OnKey fuction in at least one of my own files, but that was to disable the Delete key on a particular worksheet.

Still, I'll explore further. Any other ideas still welcome....

 

[Richie(UK)]

Hi,

Sorry, should have elaborated. The 'closing code' would be something like this:

Sub GoAway()
    Application.OnKey "%{F11}", "NoVBE"
End Sub

Sub NoVBE()
    MsgBox "No VBE via keys!"
End Sub

It would then be re-enabled with:

Sub ComeBack()
    Application.OnKey "%{F11}"
End Sub

Try running the last routine on its own (if you can access the VBE via the Tools menu) and see if that works for you. The Analysis Toolpak add-in wouldn't cause this to happen, if this is the cause its more likely a third party workbook / add-in.

When did you first notice the problem? Does that time match with any newly used workbooks? In the meantime, try using Alt&F11 in Word just to check that the key combination itself is working (ie test whether its a keyboard problem)

 

[Jolly Green Giant]

Thanks for your continuing help Richie.

Here's the gen:

Your code didn't fix things. Thanks anyway.

Alt-F11 doesn't work in Word either, (though as I said, the keys work individually - and incidentally in the "Alt-Shift-F11" combination for opening the Script Editor.)

So I reckon you're right. It's a keyboard fault affecting the logic of *that* combination only (Alt + F11).

I'm resigning myself to (and already getting used to) invoking the VBE via the menu choices with Alt-T, then M, then V. This is not too bad. I already use Alt-T, M, R for recording and stopping recording....!

Thanks for all your help. I'm glad I've 'joined the board'.

 

[TommyGun]

Probably not related (since you mention it also happens in Word), but maybe this would help too...http://support.microsoft.com/default.aspx?scid=kb;en-us;165258

 

[Jolly Green Giant]

Thanks TommyGun, well done for finding this!

In fact, I think you're right - it's unrelated. I'm on Excel 2000 and have this problem even with empty new file with no controls on the page at all.

But thanks for the thought.

 

[dl7631]

I know it's was a really old threat - but the problem can still come up today.
I am posting one simple solution - just to make sure one can find it on mrexcel.com
If your Alt+F11 suddenly stops working - try a simple solution first:
Check out your keyboard. Most likely it's not a basic keyboard anymore - it probably has some fancy functions (e.g., e-mail related like "Send" or "Reply"). Notice - there is a key that says "F Lock" or "F" or "Function Lock" (it's usually on the upper right part of the keyboard). Well, press it (a little light will go on)!
Now - you can use your favorite keys (like Alt+F11 or F4). Until you do that - they won't work or will work in a strange way (doing not what you expect them to do).
Cheers!

 

[jns]

there is a key that says "F Lock" or "F" or "Function Lock" (it's usually on the upper right part of the keyboard). Well, press it (a little light will go on)!

Thank you for posting this! I kept hitting ALT + F8 and little icons would pop up around the ribbon but wouldn't activate the macro and I couldn't figure this out for weeks! Stupid F Lock.

Thanks

 

[Sumbo20]

Thanks dl7631, I know this is well over two years old now, but the dang F Lock got me too. Thanks for the post.